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
