-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