DB2 Create Trigger

The DB2 Create Trigger Tool allows users to create triggers for a database. The following example is output for DB2.

CREATE TRIGGER TESTUSER.TEST_TRIGGER -- [NO CASCADE] BEFORE, AFTER, INSTEAD OF -- INSERT, DELETE, UPDATE [OF ] ON -- table_name -- REFERENCING OLD AS OLDROW NEW AS NEWROW FOR EACH -- ROW OR STATEMENT -- can insert action here -- WHEN (search_condition) -- can insert sql procedural statement here