In this blog post, let’s learn about the error message “4504 Non-unique ON clause cannot be specified with an INSERT clause.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4504 Non-unique ON clause cannot be specified with an INSERT clause.
Reason for the Error
You specified an on-unique ON clause and the MERGE statement also contains an INSERT clause.
Solution
When INSERT clause is specified in the MERGE statement, non-unique ON clause is not allowed. Remove INSERT clause or specify a unique ON clause and resubmit the MERGE statement
