DB2 Error Code – +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 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.