logo  
Google
 

DB2 SQL-Error: -989

SQLState: 560C3

Short Description: AFTER TRIGGER ATTEMPTED TO MODIFY A ROW IN TABLE THAT WAS INSERTED BY AN INSERT STATEMENT WITHIN A SELECT STATEMENT

An INSERT statement was specified in the FROM clause of a SELECT statement of a subselect or a SELECT INTO statement, but the underlying target base table of the INSERT has an AFTER trigger defined which modifies the table being inserted. This is disallowed. System action: The statement cannot be processed. Programmer response: Avoid using the INSERT statement within SELECT, or change the trigger so that it does not modify the table that is the target of the INSERT statement.

 <-  BACK TO INDEX