Create Trigger: SQL statement panel

You use the Create Trigger: SQL statement panel to specify SQL statement(s) to be executed when the trigger is activated. You must use a semicolon to separate multiple SQL statements, but you do not need to enclose the statements in BEGIN ATOMIC … END keywords; they are added automatically if omitted.

Panel and field definitions

  Process   Options   Utilities   Help
                                                                                
 FM/Db2 (DFG2)               Trigger SQL statement


    Triggered SQL Statement (required, separate with semicolons)
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               
                                                                               





 Command ===>                                                                   
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel
Triggered SQL Statements
Freeform entry area for the trigger SQL. Enter one or more SQL statements separated by semicolons.

Parent panels

Child panels

None.

Related tasks