Create Trigger: Details panel

Panel and field definitions

  Process   Options   Utilities   Help
                                                                                
 FM/Db2 (DFG2)              Create Trigger: Details

 Trigger:
    Order (required)                   Type (required)
       1. No cascade before               1. Insert
       2. After                           2. Delete
                                          3. Update
    Columns (optional, separate by comma)
                                                                            +

 Trigger Table:
    Owner . . . . . . .                   + (optional)
    Name  . . . . . . .                                                     +

 Referencing Old:
    Correlation name  .                   + (optional)
    Table identifier  .                   + (optional, after trigger)

 Referencing New:
    Correlation name  .                   + (optional)
    Table identifier  .                   + (optional, after trigger)

    Executed (Required)
       1. For each modified row
       2. Once (After Trigger)
 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel

No cascade before

Defines the trigger as a before trigger.

After

Defines the trigger as an after trigger.

Type

Insert

The trigger is executed when a row is inserted in the trigger table.

Delete

The trigger is executed when a row is deleted from the trigger table.

Update

The trigger is executed when a row is updated from the trigger table.

Columns

Specifies a list of columns to restrict the execution of an update trigger to updates on the specified columns.

Name

Name of the table against which an action causes the trigger to be executed.

Owner

Owner of the trigger table.

Old correlation name

Correlation name used to reference rows as they were before the triggering SQL operation.

New correlation name

Correlation name used to reference rows as they were after the triggering SQL operation.

Old table identifier

Temporary table identifier used to reference the complete set of rows as they were before the SQL operation.

New table identifier

Temporary table identifier used to reference the complete set of rows as they were after the SQL operation.

1. For each modified row

The trigger option is executed for each modified row of the trigger table.

2. Once (After Trigger)

The trigger action is executed only once for the triggering SQL operation.