In this post, you’ll learn about the error message -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 in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-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
Reason for the Error
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.
Solution
Verify that table definitions are current, and that the host variable has the proper data type.� See the explanation for SQLCODE -405 for ranges of SQL data types.