Create Trigger: Details panel
You use the Create Trigger: Details panel to specify information to define the type of trigger to be created.
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.
Parent panels
Child panels
None.