Neoview Messages Manual (R2.2)
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.
SQL 11101
11101 MXUDR: Unknown message type: value.
Cause The HP Neoview database UDR server received a request message with an unknown
message type.
Effect The request message is rejected, and the HP Neoview SQL statement fails.
Recovery Do not attempt recovery. HP support will perform recovery operations in response
to an automatically generated dial-out message about this condition.
216 Trigger, UDR Server, and Language Manager Messages (11000 Through 11399)