Previous Topic: RoutineNext Topic: Distinct Type


Trigger

A trigger is a schema object that defines a set of actions (SQL statements) that are executed when a specific SQL data change operation occurs in a specified table. Triggers provide automatic execution of a set of SQL statements whenever a specified event occurs. These SQL statements can validate and edit database changes, read and modify the database, and invoke functions that perform operations inside and outside the database.

When you select triggers from the Investigator, CA Chorus displays cross-reference information for all triggers defined in the DB2 system.