In this post, you’ll learn about the error message -302 the value of input variable number position-number is invalid or too large for the target column or the target value in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-302 the value of input variable number position-number is invalid or too large for the target column or the target value
Reason for the Error
The value of the input host variable, whose entry in the input SQLDA is indicated by ‘position-number’, was found to be invalid or to be too large to fit in the corresponding column of the table or the corresponding target value.� One of the following has occurred:
Solution
Correct the application program.� Check the column type and length of the value or the data type and contents of input host variable ‘position-number’.� Ensure that the value of the host variable will fit in the column or contains valid decimal data.� Valid decimal data is a System/370 packed decimal number.
