In this blog post, let’s learn about the error message “3053 Duplicate PRIMARY KEY clauses were specified in column definition name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3053 Duplicate PRIMARY KEY clauses were specified in column definition name.
Reason for the Error
You defined column name with more than one PRIMARY KEY clause.
Solution
Define the column with only one PRIMARY KEY clause and resubmit
