数据库触发器报错

          row in table "" that was modified by an SQL

          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