Triggered Action on a Table

The Triggered Action specifies a list of SQL statements to execute when a trigger is activated. The BEFORE, FOR EACH ROW, and AFTER sections of the Action Clause can each specify different list of triggered actions for the same trigger.

(1)

1 + ,?  WHEN (  %Condition1 ) (
2.1+ ,
2.1  %INSERT Statement2
2.1  %DELETE
Statement3
2.1  %UPDATE Statement4
2.1  %EXECUTE
PROCEDURE Statement5
2.1  %EXECUTE FUNCTION Statement6
1 )

For a trigger on a table, the trigger action consists of an optional WHEN condition and the action statements. You can specify a triggered-action list for each WHEN clause, or you can specify a single list (of one or more trigger actions) if you include no WHEN clause.

Database objects that are referenced explicitly in the trigger action or in the definition of the trigger event, such as tables, columns, and UDRs, must exist when the CREATE TRIGGER statement defines the new trigger.

CREATE TRIGGER up_itemqty
   UPDATE OF quantity ON items
   BEFORE(EXECUTE PROCEDURE upd_items_p1);