4同行回答
错误的解释：
SQL0989N AFTER trigger " row in table "
data change statement within a FROM clause.
Explanation:
An SQL data change statement was specified in the FROM clause,
but the underlying target base table of the SQL data change
statement has an AFTER trigger defined which modifies the same
table. This is disallowed.
The statement cannot be processed.
User Response:
Avoid using the SQL data change statement within a FROM clause,
or change the trigger so that it does not modify the table that
is the target of the SQL data change statement.
sqlcode : -0989
sqlstate : 560C3
收起SQL0909N The object has been deleted.
Explanation:
The application program has either (1) dropped a table and then
attempted to access it, or (2) dropped an index and then tried to access
its object table using that index.
User response:
The logic of the application program must be corrected such that it does
not attempt to access or use an object after it has been dropped.
Dropping indexes within an application program is especially hazardous,
because there is no way of determining whether or not the plan that has
been generated for the application (by BIND or REBIND) actually uses a
particular index for access to its object table.
sqlcode: -909
sqlstate: 57007
收起