-304 A VALUE WITH DATA TYPE data-type1 CANNOT BE ASSIGNED TO A HOST VARIABLE BECAUSE THE VALUE IS NOT WITHIN THE RANGE OF THE HOST VARIABLE IN POSITION position-number WITH DATA TYPE data-type2

Explanation

A CALL, FETCH, SELECT, VALUES INTO, or SET assignment statement with a host variable list or structure in position number position-number failed because the host variable with data type data-type2 was not large enough to hold the retrieved value with data type data-type1.

System action

The statement cannot be processed. No data was retrieved. If the statement was a FETCH, the cursor remains open.

Programmer response

Verify that table definitions are current, and that the host variable has the correct data type. See the explanation for SQLCODE -405 for ranges of SQL data types.

SQLSTATE

22003