.-NO CASCADE-. >>-CREATE TRIGGER--trigger-name--+-+------------+--BEFORE-+-----> +-AFTER------------------+ '-INSTEAD OF-------------' >--+-INSERT------------------------------+--ON--+-table-name-+--> +-DELETE------------------------------+ '-view-name--' '-UPDATE--+-------------------------+-' | .-,---------------. | | V | | '-OF------column-name---+-' >--+-------------------------------------------------------------------+--> | .--------------------------------------------------. | | V .-ROW-. .-AS-. (1) | | '-REFERENCING----+-OLD--+-----+--+----+--correlation-name--+------+-' | .-ROW-. .-AS-. | +-NEW--+-----+--+----+--correlation-name--+ | .-AS-. | +-+-OLD TABLE-+--+----+--table-identifier-+ | '-OLD_TABLE-' | | .-AS-. | '-+-NEW TABLE-+--+----+--table-identifier-' '-NEW_TABLE-' .-FOR EACH STATEMENT-. .-MODE DB2SQL-. >--+--------------------+--+-------------+--triggered-action--->< '-FOR EACH ROW-------' '-MODE DB2ROW-'
triggered-action: |--+----------------------+--+------------------------------+----SQL-trigger-body----| '-SET OPTION-statement-' '-WHEN--(--search-condition--)-' SQL-trigger-body: |--+-SQL-control-statement-----------------------+--------------| +-fullselect----------------------------------+ +-ALLOCATE DESCRIPTOR-statement---------------+ +-ALTER PROCEDURE (External)-statement--------+ +-ALTER SEQUENCE-statement--------------------+ +-ALTER TABLE-statement-----------------------+ +-COMMENT statement---------------------------+ +-CREATE ALIAS-statement----------------------+ +-CREATE DISTINCT TYPE-statement--------------+ +-CREATE FUNCTION (External Scalar)-statement-+ +-CREATE FUNCTION (External Table)-statement--+ +-CREATE INDEX-statement----------------------+ +-CREATE PROCEDURE (External)-statement-------+ +-CREATE SCHEMA-statement---------------------+ +-CREATE SEQUENCE-statement-------------------+ +-CREATE TABLE-statement----------------------+ +-CREATE VIEW-statement-----------------------+ +-DEALLOCATE DESCRIPTOR-statement-------------+ +-DECLARE GLOBAL TEMPORARY TABLE-statement----+ +-DELETE-statement----------------------------+ +-DESCRIBE-statement--------------------------+ +-DESCRIBE INPUT-statement--------------------+ +-DESCRIBE TABLE-statement--------------------+ +-DROP-statement------------------------------+ +-EXECUTE IMMEDIATE-statement-----------------+ +-GET DESCRIPTOR-statement--------------------+ +-GRANT-statement-----------------------------+ +-INSERT-statement----------------------------+ +-LABEL-statement-----------------------------+ +-LOCK TABLE-statement------------------------+ +-REFRESH TABLE-statement---------------------+ +-RELEASE-statement---------------------------+ +-RELEASE SAVEPOINT-statement-----------------+ +-RENAME-statement----------------------------+ +-REVOKE-statement----------------------------+ +-SAVEPOINT-statement-------------------------+ +-SELECT INTO-statement-----------------------+ +-SET CURRENT DEBUG MODE-statement------------+ +-SET CURRENT DEGREE-statement----------------+ +-SET DESCRIPTOR-statement--------------------+ +-SET ENCRYPTION PASSWORD-statement-----------+ +-SET PATH-statement--------------------------+ +-SET SCHEMA-statement------------------------+ +-SET TRANSACTION-statement-------------------+ '-UPDATE-statement----------------------------'
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.