DSNU1234I csect-name - NUMERIC CONVERSION ERROR OCCURRED FOR FIELD field-name, TABLE table-name

Explanation

The UNLOAD utility encountered an error when it tried to convert a data of one numeric type to another.

System action

The record in error will not be unloaded to the output data set. The UNLOAD utility continues until the total number of records in error reaches the value specified by the MAXERR option (the default is 1).

If the total number of records reaches the MAXERR value, the UNLOAD utility issues the DSNU1219I message and terminates with the return code 8.

User response

To eliminate any numeric overflow error, specify the same numeric data type for the output as the base type of the columns in the table. Convert numeric types only when it is known that the range of the source data fits in the allowable range of the specified numeric type for the output.

Problem determination

This message is issued most likely when an overflow occurs in converting a data of one numeric type to another. For example, an attempt to convert an INTEGER 32768 to a SMALL INT causes an overflow.

Severity

4 (warning)