Kbase P26179: Progress overflow error 9891 with the AS/400
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress/400 DataServer
Progress 9.1x
Progress 8.3B
SYMPTOM(s):
IBM AS/400 (RISC)
Overflow occurred for value <value> because the field length is <length>. The character field was truncated (9891)
ERROR-STATUS:ERROR flag does not get raised.
Trying to update a field using the Progress/400 DataServer with data that is too long for the length of the field will result in a 9891 warning. This is a warning that data has been lost.
CAUSE:
This warning was introduced with 8.3B. Previous versions did not warn that data truncation had occurred. Error 9891 raises a non-fatal error condition: the transaction continues and ERROR-STATUS:ERROR flag is not set.
FIX:
The character fields on AS/400 are fixed length. The error 9891 occurs whenever the string must be truncated to fit the field length. In order to suppress the warning use the NO-ERROR option. Then trap the message by using the syntax, ERROR-STATUS:NUM-MESSAGES > 0.