Kbase P71389: CPF5029 when updating a date field in RPG program
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/03/2004 |
|
Status: Unverified
FACT(s) (Environment):
IBM AS/400 (RISC)
FACT(s) (Environment):
Progress/400 DataServer
SYMPTOM(s):
Data mapping error when updating a date field in RPG program
Unable to update the date field from RPG program when Progress unknown value is assigned to it
CPF5029: "Data mapping error on member <member_name>"
CAUSE:
RPG program doesn't "understand" the unknown value set by Progress.
When the record is created in the native AS/400 language program (RPG) and a null value date ('9999-12-31') is assigned, it can be updated later as the AS/400 recognizes this value. Whereas it doesn't recognize the null value from the Progress client ('-').
FIX:
Compile the RPG program with ALWNULL(*USRCTL) option, for example:
CRTBNDRPG PGM(&O/&N) SRCFILE(&L/&F) DBGVIEW(*SOURCE) CVTOPT(*DATETIME
*VARCHAR) TGTRLS(*CURRENT) ALWNULL(*USRCTL)