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-2
Recovery. The trigger can only be created if you drop and re-create the subject table
with a name that is less than 123 characters.
SQL 11006
Cause. Rowsets were used in a statement that is a trigger event.
Effect. The operation fails
Recovery. Either remove the rowset from the statement or drop all triggers defined on
the table and operation that caused the error. For example, if the operation is a delete,
you need to drop all delete triggers defined on the DELETE statement target table. If
the triggers cannot be dropped, avoid the use of rowsets.
SQL 11010
Cause. You attempted to specify a statement granularity for a BEFORE trigger, which
is not supported.
Effect. The operation fails.
Recovery. Either specify a row granularity or do not specify a granularity. Row
granularity is the default for BEFORE triggers.
SQL 11011
Cause. You attempted to create an INSERT or DELETE trigger that has an explicit
column list.
Effect. The operation fails.
Recovery. Specify a trigger without the explicit column list.
SQL 11012
Cause. You attempted to create an INSERT trigger specifying an OLD transition
variable.
11006 Use of rowsets with statements involving triggers is
not supported.
Note. As of the ABU SPR, this message is no longer generated.
11010 A BEFORE trigger works only at row granularity.
11011 Only an UPDATE trigger may specify explicit columns.
11012 An INSERT trigger cannot reference OLD values.