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-5
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.
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.
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.
11023 Subqueries are currently not supported in the WHEN
clause of AFTER triggers.