Specifying a triggered action

Use the Triggered Action page of the Create Trigger notebook to specify the action that you want your trigger to invoke.

Fields and controls

Authorities and privileges

To specify the action that you want your trigger to invoke:

1. Open the Create Trigger notebook, specify values on the Trigger page, and click on the Triggered Action tab

2. If you need to reference values affected by the operation selected on the Trigger page, specify one or two correlation names for rows that contain these values:

   • In the Correlation name for the old rows field, you can type a name for the rows as they are before they're deleted or updated.

   • In the Correlation name for the new rows field, you can type a name for the rows as they are after they're inserted or updated.

3. If you need to reference values in all rows affected by the operation selected on the Trigger page, specify one or two temporary tables that consist of these rows:

   • In the Temporary table for the old rows field, you can type a name for a temporary table of rows as they are before they're deleted or updated.

   • In the Temporary table for the new rows field, you can type a name for a temporary table of rows as they are after they're inserted or updated.

4. Under For each, select a radio button to specify whether the triggered action is to occur when the selected operation acts on each row, or when the operation is over.

5. In the Triggered action field, specify the SQL for the triggered action.

6. Click on Apply to create the trigger. If you specified a new schema in the Trigger Schema field, and you have IMPLICIT_SCHEMA authority, the new schema will be added to the database.

7. Optional: Use the Create Trigger notebook to create another trigger.

8. Click on Close. The Create Trigger notebook closes.

Related information

• Creating a trigger
• CREATE TRIGGER and COMMENT ON statements -- See the SQL Reference
• Adding, changing, or deleting a comment on a trigger
• Viewing the definition of a trigger
• Dropping a trigger
• Triggers, trigger events, and triggered actions
• Interaction of triggers and constraints -- See the SQL Reference