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-4
Effect. The operation fails.
Recovery. Add a REFERENCING NEW clause to the CREATE TRIGGER statement
and resubmit.
SQL 11017
Cause. You specified a SET operation as an action for your BEFORE trigger, but the
SET assignment is to an identifier.
Effect. The operation fails.
Recovery. Prefix the assignment to the SET operation with the NEW transition
variable name and resubmit.
SQL 11018
Cause. An attempt was made during DDL to create an AFTER trigger with an
unsupported action. In particular, this error is raised if the trigger action is a compound
statement, an embedded DELETE, or an embedded UPDATE.
Effect. The operation fails.
Recovery. Add an action to the trigger statement and use a supported action for the
trigger. Before triggers support only SET and SIGNAL operations, while AFTER
triggers support INSERT, UPDATE, DELETE, and SIGNAL operations.
SQL 11019
Cause. You attempted to create a row trigger that has a scan of the transition table
either in its action or in its condition.
Effect. The operation fails.
Recovery. Depending on your application, you can either re-create the trigger as a
statement trigger, or scan from the subject table.
SQL 11020
Where name is the transition variable name.
11017 The left hand side of a SET assignment must be
qualified with the name of the NEW transition variable.
11018 An empty or unsupported trigger action was specified.
11019 Only statement triggers can scan the transition table.
11020 Ambiguous or invalid use of transition name name.