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-7
Effect. The operation fails.
Recovery. Drop all UPDATE triggers whose subject columns match those columns in
the SET ON ROLLBACK clause of the SET ON ROLLBACK statement. Matching is
satisfied if at least one of the columns updated by the SET ON ROLLBACK clause is
the same as one of the subject columns of the trigger. If the triggers cannot be
dropped, you might want to avoid performing SET ON ROLLBACK statements on the
subject columns.
SQL 11027
Cause:
•
The target table of an embedded DELETE statement is the subject table of a
DELETE trigger.
•
The target columns of an embedded UPDATE statement are the subject columns
of an UPDATE trigger.
Effect. The operation fails.
Recovery. Drop all the triggers defined on the table and operation that caused the
error. For example, if the operation is a DELETE, drop all DELETE triggers defined on
the DELETE statement target table. If the triggers cannot be dropped, do not attempt
these operations.
SQL 11028
Cause. The execution of a trigger action statement failed.
Effect. The operation fails.
Recovery. This error message will appear with another error message that states
what statement has failed, why it failed, and how to recover.
SQL 11029
Where column-name is the name of the column.
11027 Embedded Update or Delete is not allowed as a trigger
event.
11028 Action statement of trigger trigger-name on table
subject-table-name has failed.
11029 Attempt to change the value of column column-name of a
given row more than once in the same statement.
Note. As of the ABU SPR, this message is no longer generated.