In this blog post, let’s learn about the error message “20165 The number of key columns ( value1) defined on the table or index is less than the number of key columns (value2) defined in the request.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20165 The number of key columns ( value1) defined on the table or index is less than the number of key columns (value2) defined in the request.
Reason for the Error
The number of columns defined in the partitioning key for the table or index is less than the number of columns defined in the VALUE clause.
Solution
Verify the number of key columns in the table and resubmit