-989 AFTER TRIGGER `trigger-name` ATTEMPTED TO MODIFY A ROW IN TABLE `table-name` 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 where FINAL TABLE was specified,
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.

System action
The statement cannot be processed.

Programmer 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.

SQLSTATE:
560C3

-989 AFTER TRIGGER trigger-name ATTEMPTED TO MODIFY A ROW IN TABLE table-name THAT WAS MODIFIED BY AN SQL DATA CHANGE STATEMENT WITHIN A FROM CLAUSE

Explanation

System action

Programmer response

SQLSTATE:

-989 AFTER TRIGGER `trigger-name` ATTEMPTED TO MODIFY A ROW IN TABLE `table-name` THAT WAS MODIFIED BY AN SQL DATA CHANGE STATEMENT WITHIN A FROM CLAUSE