Specifies the SQL mode. Your choices are:
Mode DB2SQL
Mode DB2ROW
The distinction between DB2SQL and DB2ROW is only relevant when operations affect multiple rows in a table and Run for each row is selected. Mode DB2ROW specifies that the trigger program is run at the time each row is changed. Rows that are not yet modified by the operation appear to the trigger program to have their original values, while rows already modified show the new values. Mode DB2SQL, however, specifies that the trigger program will not run for any row until after all rows affected by the operation have been modified. All rows appear to the trigger program to have their new values.