HPE NonStop SQL/MX Error – 4506 Embedded UPDATE/DELETE statements cannot be used in a MERGE statement.

In this blog post, let’s learn about the error message “4506 Embedded UPDATE/DELETE statements cannot be used in a MERGE statement.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4506 Embedded UPDATE/DELETE statements cannot be used in a MERGE statement.

Reason for the Error

You specified an embedded UPDATE or DELETE statement in the MERGE statement.

Solution

Remove the embedded UPDATE or DELETE statement and resubmit the MERGE statement