HP NonStop SQL/MX, Messages Manual

Page: 336 / 752

Trigger, UDR Server, and Language Manager
Messages (11000 through 11399)
HP NonStop SQL/MX Messages Manual — 640324-001
13- 6
Recovery. None.
SQL 11023
Cause. You attempted to create a trigger that has a subquery in the WHEN clause of
its action.
Effect. The operation fails.
Recovery. If the trigger action is an UPDATE or DELETE, you can move the condition
to the action predicate.
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
11023 Subqueries are currently not supported in the WHEN
clause of AFTER triggers.
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.