In this post, you’ll learn about the error message -311 the length of input host variable number position-number is negative or greater than the maximum in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-311 the length of input host variable number position-number is negative or greater than the maximum
Reason for the Error
When evaluated, the length specification for input host string variable, whose entry in the SQLDA is indicated by position-number, was negative or greater than the maximum.
Solution
Correct the program to ensure that the lengths of all host string variables are not negative or that they are not greater than the maximum allowed length.
