-302 THE VALUE OF INPUT VARIABLE OR PARAMETER NUMBER position-number IS INVALID OR TOO LARGE FOR THE TARGET COLUMN OR THE TARGET VALUE

Explanation

Db2 received data that was invalid or too large to fit in the corresponding column of the table or the corresponding target value. The position-number identifies either the host variable number (if the message is issued as a result of an INSERT, UPDATE, MERGE, DELETE, SELECT, VALUES INTO, or SET assignment statement), or the parameter number (if the message is issued as the result of a CALL statement or the invocation of a function).

One of the following occurred:
  • The column is defined as a string and the host variable or parameter contains a string that is too long for the column.
  • The column is defined as numeric and the host variable or parameter contains a numeric value too large for the definition of the column.
  • The host variable is defined as decimal, but contains invalid decimal data.
  • The target value is a string constant and the host variable or parameter contains a string that is too long for the target value.
  • The target value is a numeric constant and the host variable or parameter contains a numeric value that is too large for the target value.

System action

The statement cannot be processed.

Programmer response

Correct the application program, function or stored procedure. Check the column type and length of the value or the data type and contents of the input host variable or parameter position-number. Ensure that the value of the host variable or parameter will fit in the column or contains valid decimal data. Valid decimal data is a System/370 packed decimal number.

SQLSTATE

22003 if number too large for target; 22001 otherwise.