HP Neoview Messages, Руководство пользователя

Страница: 239 / 400

12 Trigger, UDR Server, and Language Manager Messages
(11000 Through 11399)
SQL 11005
11005 Table table-name or one of its triggers is inaccessible.
table-name
is the name of the table.
Cause The object metadata is not accessible.
Effect
The operation fails.
Recovery
Make sure that no concurrent DDL operations are accessing the table. If concurrent
DDL operations are accessing the table, wait until these operations are completed, and then
retry the operation. If the problem persists, contact the GMCSC to help determine why the
error occurred.
SQL 11014
11014 A BEFORE trigger allows only SIGNAL, SET and CALL statements.
Cause
You attempted to create a BEFORE trigger with a trigger action other than SIGNAL,
SET, or CALL. Consider that the dependent descriptor might be for a trigger.
Effect The operation fails.
Recovery If SET, SIGNAL, or CALL does not work, determine whether an AFTER trigger is
more appropriate for your application. If an AFTER trigger cannot be used, you need to
implement the action in your application. If the dependent descriptor is that of a trigger, the
recovery options are:
• Drop the trigger or triggers first and reattempt the operation.
• Abandon the revoke operation.
• Use the cascade drop behavior option for revoke, and reattempt the operation. (The cascade
drop behavior, if successful, will also drop all the triggers by using the target object.)
SQL 11018
11018 An empty or unsupported trigger action was specified.
Cause An attempt was made during DDL to create an AFTER trigger with an unsupported
action. In particular, this error is raised if the trigger action is a compound statement, an
embedded DELETE, or an embedded UPDATE.
Effect The operation fails.
Recovery Add an action to the trigger statement and use a supported action for the trigger.
BEFORE triggers support only SET and SIGNAL operations. AFTER triggers support INSERT,
UPDATE, DELETE, and SIGNAL operations.
SQL 11022
11022 Trigger action SET clause error. Column column-name is not a
column in table table-name.
column-name
is the column name.
table-name
is the trigger subject table name.
Cause
You attempted to create a trigger that had a triggered action with a SET operation
that attempted to update or access a column that is not part of the subject table
table-name
.
Effect
The operation fails.
Recovery
None.
239