In this blog post, let’s learn about the error message “1089 The system generated column SYSKEY must be specified last or not specified at all in the index column list.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1089 The system generated column SYSKEY must be specified last or not specified at all in the index column list.
Reason for the Error
The system-generated SYSKEY column was not the last column in a CREATE INDEX statement.
Solution
Change the column list to place SYSKEY at the end of the list and resubmit the statement