SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Trigger, UDR Server, and Language Manager
Messages (11000 through 11399)
HP NonStop SQL/MX Messages Manual—523730-004
12-6
SQL 11024
Where var-name is the name you are attempting to assign to OLD and NEW
transition variables.
Cause. You attempted to create a trigger with a clause using the same name for both
the NEW and OLD transition variables.
Effect. The operation fails.
Recovery. Specify different names for the OLD and NEW transition variables and
resubmit.
SQL 11025
Cause:
•
An INSERT statement in a compound statement has as its target a trigger subject
table on which INSERT triggers are defined.
•
An UPDATE statement in a compound statement has as its target a trigger subject
columns on which UPDATE triggers are defined.
•
A DELETE statement in a compound statement has as its target a trigger subject
table on which DELETE triggers are defined.
Effect. The operation fails.
Recovery. Drop all triggers defined on the table and operation that caused the error.
For example, if the operation is a DELETE, drop all DELETE triggers defined on the
DELETE statement target table. If the triggers cannot be dropped, avoid performing
compound statement operations on the subject tables (or columns).
SQL 11026
Cause:
•
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.
11024 Specifying the same name, var-name, for both OLD and
NEW is not allowed.
11025 Insert, Update or Delete statement within a compound
statement is not allowed as a trigger event.
11026 SET ON ROLLBACK clause of Update or Delete statement is
not allowed to update columns on which triggers are defined.