HPE NonStop SQL/MX Error – 4511 Use of rowsets with MERGE statement is not supported.

In this blog post, let’s learn about the error message “4511 Use of rowsets with MERGE statement is not supported.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4511 Use of rowsets with MERGE statement is not supported.

Reason for the Error

You specified rowsets in the MERGE statement.

Solution

Remove the rowset references and resubmit the MERGE statement