DB2 SQL-Error: -797
SQLState: 42987
Short Description: ATTEMPT CREATE TRIGGER WITH AN UNSUPPORTED TRIGGERED SQL STATEMENT
The trigger definition includes an unsupported triggered SQL statement. The SQL statements allowed as a triggered SQL statement depend on the type of trigger: v A BEFORE trigger can include the following triggered SQL statements: – a fullselect or VALUES statement – a SET transition-variable statement (not allowed in a BEFORE DELETE trigger) – a SIGNAL SQLSTATE statement – a CALL statementv An AFTER trigger can include the following triggered SQL statements: – a fullselect or VALUES statement – an INSERT statement – a searched UPDATE statement – a searched DELETE statement – a SIGNAL SQLSTATE statement – a CALL statementSystem action: The CREATE TRIGGER statement cannot be executed, and the trigger is not created. Programmer response: Check the triggered SQL statements in the trigger for any statement that is not listed above and remove it.