In this blog post, let’s learn about the error message “11026 SET ON ROLLBACK clause of Update or Delete statement is not allowed to update columns on which triggers are defined.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11026 SET ON ROLLBACK clause of Update or Delete statement is not allowed to update columns on which triggers are defined.
Reason for the Error
The target columns of the SET ON ROLLBACK clause of a SET ON ROLLBACK UPDATE statement are the subject columns of an UPDATE trigger.
The target columns of the SET ON ROLLBACK clause of a SET ON ROLLBACK DELETE statement are the subject columns of an UPDATE trigger.
Solution
Drop all UPDATE triggers whose subject columns match those columns in the SET ON ROLLBACK clause of the SET ON ROLLBACK statement. Matching is satisfied if at least one of the columns updated by the SET ON ROLLBACK clause is the same as one of the subject columns of the trigger. If the triggers cannot be dropped, you might want to avoid performing SET ON ROLLBACK statements on the subject columns
