HPE NonStop SQL/MX Error – 4500 The MERGE statement was not prepared.

In this blog post, let’s learn about the error message “4500 The MERGE statement was not prepared.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4500 The MERGE statement was not prepared.

Reason for the Error

You issued a MERGE statement when the default attribute ENABLE_MERGE_STATEMENT is set to OFF.

Solution

Before executing Merge statement, set the ENABLE_MERGE_STATEMENT default attribute to ‘ON’