Create Trigger panel

Panel and field definitions

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

 Trigger:
    Schema  . . . . . .                   + (optional)
    Name  . . . . . . .                                                     +

 Trigger Creation:
    Creation Options
    1  1. Details                 (required)
       2. Search Conditions       (optional)
       3. SQL Statement           (required)
       4. Create the Trigger







 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel

Schema

Name of schema.

Name

Name of new trigger.

Creation Options

Specify the number of the creation option you want to use:

1. Details

To specify information to define the type of trigger to be created. Displays the Create Trigger: Details panel.

2. Search Conditions

To specify information to define the optional search condition to restrict the execution of the trigger. Displays the Create Trigger: Search Condition panel.

3. SQL statement

To specify SQL statements to be executed when the trigger is activated. displays the Create Trigger: SQL statement panel.

4. Create the Trigger

When you have finished specifying details for the trigger to be created, select this creation option to create the trigger.