In this blog post, let’s learn about the error message “1276 The PARTITION clause cannot be specified for an SQL/MP Table, SQL/MP view or SQL/MX view. The partition partition-name was specified for object table-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1276 The PARTITION clause cannot be specified for an SQL/MP Table, SQL/MP view or SQL/MX view. The partition partition-name was specified for object table-name.
Reason for the Error
The PARTITION clause was used with an SQL/MX view.
Solution
Remove the PARTITION clause and compile the statement again
