In this post, you’ll learn about the error message +117 the number of insert values is not the same as the number of object columns in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
+117 the number of insert values is not the same as the number of object columns
Reason for the Error
The number of insert values in the value list of the insert operation is not the same as the number of object columns specified.
Solution
For better performance, rebind the plan or package after correcting the statement. To correct the statement, specify one and only one value for each of the specified object columns.
