In this blog post, let’s learn about the error message “1112 An index column list cannot contain only the system-generated column SYSKEY.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1112 An index column list cannot contain only the system-generated column SYSKEY.
Reason for the Error
The column list specified in a CREATE INDEX statement consisted only of the system-generated column SYSKEY.
Solution
Change the column list to include additional columns and reissue the statement