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
