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
