-405   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

The statement cannot be processed.

Programmer response

The value of constant should be reduced to the appropriate size for this data type.

SQLSTATE

42820