Neoview Messages Manual (Volume 1) (R2.4)

SQL 11045
11045 FIRST N UPDATE or DELETE is not supported on a table that is the
subject table of BEFORE triggers or AFTER STATEMENT triggers. Trigger
trigger-name has table table-name as its subject table.
Cause A FIRST N clause was used on an UPDATE or DELETE operation of a table that is
the subject table of a BEFORE trigger or AFTER STATEMENT trigger.
Effect The statement does not compile.
Recovery Drop the trigger and recompile.
SQL 11046
11046 Host variables and dynamic parameters are not allowed in the
action of a trigger.
Cause You attempted to create a trigger that includes host variables or dynamic parameters
in its action. This can happen when you specify CALL statements or compound actions as
triggered actions.
Effect The operation fails, and the trigger is not created.
Recovery Rewrite the trigger so that host variables and dynamic parameters do not appear
in the trigger action. Then retry the operation.
SQL 11047
11047 SELECT statements are not allowed in the compound action of a
trigger.
Cause You attempted to create a trigger that includes a SELECT statement in its compound
action.
Effect The operation fails, and the trigger is not created.
Recovery Rewrite the trigger so that the SELECT statement is not present in the trigger action.
Then retry the operation.
SQL 11049
11049 Illegal use of ROW or TABLE keyword in the REFERENCING clause.
Use ROW with row triggers and TABLE with statement triggers.
Cause You attempted to create a row trigger with a referencing clause that specifies the
optional TABLE keyword, or you attempted to create a statement trigger with a referencing
clause that specifies the optional ROW keyword specified.
Effect The operation fails, and the trigger is not created.
Recovery Correct the syntax so that a row trigger uses the ROW keyword in its referencing
clause and a statement trigger uses the TABLE keyword in its referencing clause. You can
remove the optional keyword because it can be implied from the “for each clause”, if specified.
If the optional keyword is not specified, the default is “row” trigger for BEFORE triggers and
“statement” for AFTER triggers.
SQL 11050
11050 NOT ATOMIC is not allowed on compound triggered action statements.
Cause A specified triggered action statement is a non-atomic compound statement (BEGIN
NOT ATOMIC ... END), and triggered action statements can have only atomic compound
statement(s) (BEGIN ATOMIC ... END) as part of a trigger definition.
Effect The trigger definition can not compile or be prepared.
Recovery Change BEGIN NOT ATOMIC to BEGIN ATOMIC.
226 Trigger, UDR Server, and Language Manager Messages (11000 Through 11399)