Correlated Table Action

Correlated Table Action:
 
|--+----------------------------------------+------------------->
   |                                   (1)  |
   '-BEFORE--| Triggered-Action List |------'
 
                                           (1)
>--FOR EACH ROW--| Triggered-Action List |---------------------->
 
>--+---------------------------------------+--------------------|
   |                                  (1)  |
   '-AFTER--| Triggered-Action List |------'
 

1. See page Triggered-Action List

If the CREATE TRIGGER statement contains an INSERT REFERENCING clause, a DELETE REFERENCING clause, an UPDATE REFERENCING clause, or (for Dynamic Server only) a SELECT REFERENCING clause, you must include a FOR EACH ROW triggered-action list in the action clause. You can also include BEFORE and AFTER triggered-action lists, but they are optional.

For information on the BEFORE, FOR EACH ROW, and AFTER triggered-action lists, see Action Clause

In Extended Parallel Server, you cannot specify FOR EACH ROW actions on tables that have globally-detached indexes.