In this blog post, let’s learn about the error message “1080 The DDL request has duplicate references to column column-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1080 The DDL request has duplicate references to column column-name.
Reason for the Error
You attempted to create a table that has two columns with the same name. If you name a column “SYSKEY,” duplication can result from the implicit creation by NonStop SQL/MX of a column named SYSKEY to ensure uniqueness for the clustering key.
Solution
Remove duplicate column names and resubmit