The triggered SQL statement of all triggers can be a dynamic
compound statement.
That is, triggered SQL statements can contain one or more
of the following elements:
- CALL statement
- DECLARE variable statement
- SET variable statement
- WHILE loop
- FOR loop
- IF statement
- SIGNAL statement
- ITERATE statement
- LEAVE statement
- GET DIGNOSTIC statement
- fullselect
However, only AFTER and INSTEAD OF triggers can contain one
or more of the following SQL statements:
- UPDATE statement
- DELETE statement
- INSERT statement
- MERGE statement
DB2 10.5 for Linux, UNIX, and Windows