Trigger properties

Properties for IBM® data server trigger objects

For more information about specific syntax, see the reference information that is included with each database product. Syntax definitions for some database vendors or versions might differ from the following descriptions.

General page
Property Description
Name Specifies a name for the object.
Label Specifies a label that is displayed in visual diagrams.
Schema Shows the relational schema under which this object was created.
Action time Specifies an action time for the trigger.
BEFORE
Specifies that the triggered action is run before any changes are applied by an insert, delete, or update operation on the subject table.
AFTER
Specifies that the associated triggered action is to be applied after the changes that are caused by the actual update of the subject table are applied to the database.
INSTEADOF
Specifies that the associated triggered action replaces the action against the subject view. Only one INSTEAD OF trigger is allowed for each kind of operation on a given subject view.
Granularity Specifies an option for the granularity of the triggered action. You can select ROW (FOR EACH ROW) or COLUMN (FOR EACH COLUMN).
Insert Specifies that the trigger action occurs when an INSERT statement is run on the table or view. For some data servers, you can only specify one trigger action.
Delete Specifies that the trigger action occurs when an DELETE statement is run on the table or view. For some data servers, you can only specify one trigger action.
Update Specifies that the trigger action occurs when an UPDATE statement is run on the table or view. For some data servers, you can only specify one trigger action.
Update columns Available only if the Update check box is selected. In edit mode, click the ellipsis [...] button to open a window so that you can select update columns. The grid shows the name and data type for the columns that you selected.
Details page
Property Description
Old row Specifies a correlation name that identifies the row state prior to the triggering SQL operation.
New row Specifies a correlation name that identifies the row state as modified by the triggering SQL operation and by any SET statement in a BEFORE trigger that has already run.
Old table Specifies a temporary table name identifier for the OLD_TABLE_AS clause.
New table Specifies a temporary table name identifier for the NEW_TABLE_AS clause.
When clause Specifies a search condition for the triggered action.
Action body Specifies an SQL procedure statement for the triggered action.
Documentation page
Specifies user-supplied information about the object.
Annotation page (in edit mode only)
Add, modify, or delete properties.

Feedback