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-3
Effect. The operation fails.
Recovery. You cannot use the OLD transition variable with an INSERT trigger
because there is no old image for a row to be inserted.
SQL 11013
Cause. You attempted to create a DELETE trigger specifying a NEW transition
variable.
Effect. The operation fails.
Recovery. You cannot use the NEW transition variable with a DELETE trigger
because there is no new image for a row to be deleted.
SQL 11014
Cause. You attempted to create a BEFORE trigger with a trigger action other than
SIGNAL or SET.
Effect. The operation fails.
Recovery. If SET or SIGNAL does not work, determine whether an AFTER trigger is
more appropriate for your application. If an AFTER trigger cannot be used, you will
need to implement the action in your application.
SQL 11015
Cause. You attempted to use the SET operation as an action for an after trigger.
Effect. The operation fails.
Recovery. You cannot modify the transition name in an AFTER trigger. Use the
UPDATE statement instead as an action for the trigger.
SQL 11016
Cause. You attempted to use the SET operation in a BEFORE trigger but the
REFERENCING NEW clause is missing from the CREATE TRIGGER statement.
11013 A DELETE trigger cannot reference NEW values.
11014 A BEFORE trigger allows only SIGNAL and SET operations.
11015 An AFTER trigger does not support the SET operation.
11016 A BEFORE trigger that uses SET must have REFERENCING
NEW clause.