SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

HP NonStop SQL/MX Messages Manual—523730-004
12-1
12
Trigger, UDR Server, and Language
Manager Messages (11000 through
11399)
SQL 11001
Cause. More than 256 triggers were encountered during the statement compilation,
which is not supported.
Effect. The operation fails.
Recovery. Either rewrite the statement so that fewer triggers are generated, or
redesign the triggers so that the triggering graph is not as deep.
SQL 11003
Where TriggerName is the name of one of the triggers in the triggering cycle.
Where TableName is the subject table name of trigger TriggerName.
Cause. During execution, a trigger was generated recursively more than 16 times.
Effect. The operation fails.
Recovery. The threshold of 16 is hard-coded and cannot be changed. You can either
rewrite your statement or redesign your triggers for less trigger recursion by adding
conditions to your trigger actions.
SQL 11004
Cause. You attempted to create a trigger on a subject table whose name length
exceeds 122 characters. The maximum length of a user table is 128 characters.
However, triggers require an internal temporary table whose name is derived from the
subject table name, which is an additional six characters.
Effect. The operation fails.
11001 There are more than 256 triggers in this statement.
11003 Trigger TriggerName on table TableName was triggered
recursively more than 16 times.
11004 Triggers cannot be created on tables with names longer
than 122 characters.