SQL/MX 2.x Messages Manual (H06.04+)

Trigger, UDR Server, and Language Manager
Messages (11000 through 11399)
HP NonStop SQL/MX Messages Manual—540498-003
12-5
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 ColumnName is the column name.
Where TableName 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 TableName.
Effect. The operation fails.
Recovery. None.
11020 Ambiguous or invalid use of transition name name.
11021 The subject table name cannot be used in the
REFERENCING clause.
11022 Column ColumnName is not a column in table TableName,
and so cannot be SET into.