HPE NonStop SQL/MX Error – 4199 SET ON ROLLBACK clause cannot be specified when clustering key columns are specified in the SET clause of an UPDATE statement.

In this blog post, let’s learn about the error message “4199 SET ON ROLLBACK clause cannot be specified when clustering key columns are specified in the SET clause of an UPDATE statement.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4199 SET ON ROLLBACK clause cannot be specified when clustering key columns are specified in the SET clause of an UPDATE statement.

Reason for the Error

You specified the SET ON ROLLBACK clause while updating the clustering key columns.

Solution

Remove the SET ON ROLLBACK clause and recompile the statement