Figure 3
Using a transition table in an update trigger

CREATE TRIGGER accounttrigger
AFTER UPDATE ON accounts
REFERENCING NEW_TABLE AS newtable
FOR EACH STATEMENT MODE DB2SQL
BEGIN
DECLARE chgcnt INT;
SET chgcnt = (SELECT count(*) FROM newtable);

INSERT INTO account_changes
         VALUES('I',CURRENT TIMESTAMP,CURRENT USER, chgcnt);
END