In this post, you’ll learn about the error message -313 the number of host variables specified is not equal to the number of parameter markers in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-313 the number of host variables specified is not equal to the number of parameter markers
Reason for the Error
The number of host variables specified in the EXECUTE or OPEN statement is not the same as the number of parameter markers (question marks) appearing in the prepared SQL statement.
Solution
Correct the application program so that the number of host variables specified in the EXECUTE or OPEN statement is the same as the number of parameter markers appearing in the prepared SQL statement.