IBM Books

Time to trigger action

Select a radio button to specify when the triggered action is to occur:

Before
The action precedes the operation that causes the trigger to be executed. You select this operation (inserting rows, deleting them, or updating them) on the Trigger page.

Attention: If you select theBefore radio button, the trigger will not cause other triggers to be activated.

After
The action follows the operation that causes the trigger to be executed. If you select the Row radio button on the Triggered Action page, the action occurs after the operation acts on each row. If you select the Statement radio button, the action occurs after the operation acts on all rows.

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

[ DB2 List of Books | Search the DB2 Books ]