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 FETCH or SELECT into a host variable list or structure, position number ‘position-number’ failed because the host variable having data type ‘data-type2’ was not large enough to hold the retrieved value having data type ‘data-type1’.
Solution
Verify DCLGEN host variable definitions are current with DB2 catalog table/view attributes.