In this post, you’ll learn about the error message -301 the value of input host variable number position-number cannot be used as specified because of its data type in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-301 the value of input host variable number position-number cannot be used as specified because of its data type
Reason for the Error
The input host variable in the input SQLDA whose entry number is indicated by ‘position-number’, could not be used as specified in the statement because its data type is incompatible with the requested function.
Solution
Verify that the data type of the indicated input host variable in the statement is compatible with the manner in which it is used.