-406   A CALCULATED OR DERIVED NUMERIC VALUE IS NOT WITHIN THE RANGE OF ITS OBJECT COLUMN

Explanation

A value derived or calculated during processing of the SQL statement was outside the range of the data type of its object column. This problem might have arisen for one of the following reasons:
  • The values occurring in the object column were out of range.
  • The SQL operation performed was not appropriate for the values in the object column.
  • A DECIMAL(19,0) column is altered to BIGINT, but a value in the column is outside the range of BIGINT.

System action

The statement cannot be processed.

Programmer response

See the explanation of SQLCODE -405 for allowed ranges for numeric data types.

If the error occurred while accessing a table column that was altered from DECIMAL(19,0) to BIGINT, alter the column data type back to DECIMAL(19,0) and refer description of the ALTER TABLE statement for information about how to change DECIMAL(19,0) columns to BIGINT.

SQLSTATE

22003