Operation that causes the trigger to be executed

Select a radio button to specify the type of operation that will cause the trigger to be executed:

Insert

Inserting rows into the table.

Delete

Deleting rows from the table.

Update of columns

Updating rows in one or more columns.

Use the box below this radio button to indicate which columns must be updated for the trigger to be executed. If you want specific columns to be updated, select these columns.

Tip: To select multiple columns one by one, press and hold the Ctrl key while you click on the columns. To select consecutive columns at one time, click on the first one and scroll to the last one; then press and hold the Shift key while you click on the last one.

If you don't select any columns, the trigger can be executed when any columns are updated.

If the code for the triggered action contains a search condition, the trigger will be actually executed only when columns that meet this condition are updated.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]