Trigger properties (DB2)

Use the Properties view to modify the properties of a DB2® trigger.

For more information about DB2 syntax, see the reference information that is included with each product. There may be differences between DB2 syntax and the syntax for other vendors.

General page
Property Description
Name Type a name.
Label Type a label. This label is displayed in visual diagrams.
Schema Specify a relational schema under which to create this object.
Action time Select an action time for the trigger. You can select BEFORE, AFTER, or INSTEADOF.
Granularity Select an option for the granularity of the triggered action. You can select ROW (FOR EACH ROW) or COLUMN (FOR EACH COLUMN).
Insert Select to specify that the trigger action occurs when an INSERT statement is run on the table or view.
Delete Select to specify that the trigger action occurs when an DELETE statement is run on the table or view.
Update Select to specify that the trigger action occurs when an UPDATE statement is run on the table or view.
Update columns Available only if you select the Update check box. 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 Specify a correlation name which identifies the row state prior to the triggering SQL operation.
New row Specify a correlation name which identifies the row state as modified by the triggering SQL operation and by any SET statement in a BEFORE trigger that has already executed.
Old table Type a temporary table name identifier for the OLD_TABLE_AS clause.
New table Type a temporary table name identifier for the NEW_TABLE_AS clause.
When clause Type a search condition for the triggered action.
Action body Type a SQL procedure statement for the triggered action.
Documentation page
Type information about the object.
Annotation page
Add or delete properties and edit their values.

Feedback