HBO0349I Due to overflow, data values in table were changed to null in n columns.
Explanation
An overflow occurs during the execution of a COLLECT or LIST RECORD statement when the result of an accumulation function is too large to be stored in a column.
In the case of COLLECT, the column is in the target table, and its capacity is determined by the data type of the column.
In the case of LIST RECORD, the column is a part of the output list, and its capacity is determined by the type of expression that defines it.
According to the options that are defined for the statement, the processing is to continue if an overflow occurs. When an overflow occurs, the current value of the accumulation function is discarded, the column is reset to null, and the accumulation continues, starting from null.
Processing continues.
Response
Refer to the HBODUMP file for more information. Determine whether the overflow was caused by an incorrectly defined argument of the accumulation function. Review the source record or row to determine whether the overflow was caused by invalid data. If the statement is LIST RECORD, consider modifying the argument of the accumulation function to change the type of the result from integer to floating point.