HP NonStop SQL/MX, Messages Manual

Page: 335 / 752

Trigger, UDR Server, and Language Manager
Messages (11000 through 11399)
HP NonStop SQL/MX Messages Manual — 640324-001
13- 5
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.
Cause. You attempted an INSERT/UPDATE/DELETE from the transition table during
the operation of a trigger. Transition tables are read-only.
Effect. The operation fails.
Recovery. Correct the create trigger statement and resubmit.
SQL 11021
Cause. You attempted to use the subject table name as a transition variable name.
Effect. The operation fails.
Recovery. Use a different name for the transition variable name and resubmit.
SQL 11022
Where
column-name
is the column name.
Where
table-name
is the trigger subject table name.
Cause. You attempted to create a trigger that had a triggered action with a SET
operation that attempted to update or access a column that is not part of the subject
table
table-name
.
Effect. The operation fails.
11019 Only statement triggers can scan the transition table.
11020 Ambiguous or invalid use of transition name name .
11021 The subject table name cannot be used in the
REFERENCING clause.
11022 Trigger action SET clause error. Column column-name is
not a column in table table-name .