In this blog post, let’s learn about the error message “1088 The system generated column SYSKEY must be specified last or not specified at all in the STORE BY column list.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1088 The system generated column SYSKEY must be specified last or not specified at all in the STORE BY column list.
Reason for the Error
If the system-generated column SKSKEY is specified in the STORE BY list of columns, it must be specified last.
Solution
Correct the STORE BY clause and resubmit