Background documentation-3016: Invalid numeric constant Locate this document in the navigation structure

 

Explanation

  1. The specified number does not match the column data type.

  2. The specified length of the function's result, for example, LPAD, CHR, and so on, is invalid.It must be between 1 and the maximum length valid for a CHAR-type column.

User Response

  1. Use a QUERY statement issued on the system table DOMAIN.COLUMNS to find out the data type of the affected column.

  2. Correct the specified length of the function’s result.