HPE NonStop SQL/MX Error – 1042 All PRIMARY KEY or UNIQUE constraint columns must be NOT NULL.

In this blog post, let’s learn about the error message “1042 All PRIMARY KEY or UNIQUE constraint columns must be NOT NULL.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1042 All PRIMARY KEY or UNIQUE constraint columns must be NOT NULL.

Reason for the Error

You did not specify NOT NULL on one or more columns that are included in a UNIQUE or PRIMARY KEY constraint.

Solution

Reissue the statement with NOT NULL specified for all columns that are in the PRIMARY KEY and UNIQUE constraints