DSNH405I E csectname THE NUMERIC CONSTANT constant CANNOT BE USED AS SPECIFIED BECAUSE IT IS OUT OF RANGE

Explanation

The numeric constant is not in the proper range.

The proper ranges for SQL values are as follows:
  • 5.4E-79 to 7.2E+75 for FLOAT values
  • -(1031 -1) to +(1031 -1) for DECIMAL values
  • -2147483648 to 2147483647 for INTEGER values
  • -32768 to +32767 for small integer (SMALLINT) values
  • -9.999999999999999x10-383 to 9.999999999999999x10384 for DECFLOAT(16) values
  • -9.999999999999999999999999999999999x10-6143 to 9.999999999999999999999999999999999x106144 for DECFLOAT(34) values
  • - 9223372036854775808 to +9223372036854775807 for big integer (BIGINT) values

System action

If the containing SQL statement is a declaration, it is discarded. If the containing SQL statement is executable, it is replaced by host language statements that will, if executed, set an error code in the SQLCA.

User response

Correct the number.

Severity

8 (error)