Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram                                   .-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-'
 
Notes:
  1. The same clause must not be specified more than once.
Read syntax diagramSkip visual syntax diagramtriggered-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----------------------------'