Creating Models › Target Servers for Physical Models › Database Property Editors › DB2 LUW Property Editors › Define a DB2 LUW Table Trigger
Define a DB2 LUW Table Trigger
Use the Table Trigger Editor to define the triggers that exist for a table in a DB2 LUW physical model.
To define a DB2 LUW table trigger
- Right-click the table for which you want to define a trigger and click Trigger Properties.
The DB2 for LUW Table Trigger Editor opens.
- Select the table trigger in the Navigation Grid that you want to define and work with the following options:
Note: Click New on the toolbar to create a table trigger. Use the Enter filter text text box to filter a large list of table triggers to locate the one that you want to define.
- Name
-
Displays the table trigger name. You can change the trigger name in this field.
- Schema
-
Specifies the schema for the table trigger. Select a schema from the drop-down list.
- Insert
-
Specifies to execute the table trigger on INSERT.
- Update
-
Specifies to execute the table trigger on UPDATE.
- Delete
-
Specifies to execute the table trigger on DELETE.
- Fire
-
Specifies when the table trigger is executed.
- Replace
-
Specifies to use the REPLACE syntax for the table trigger.
- Generate
-
Specifies whether or not to generate DDL for this object during Forward Engineering.
- Click the General tab and define properties and referential integrity constraints.
- Click the Update Columns tab to specify columns to use for the UPDATE execution.
- Click the Code tab to define the trigger body for the table trigger.
- Click the Expanded tab to view expanded code for the table trigger.
- Click the Comment tab and enter any comments that you want to associate with the table trigger.
- Click the UDP tab to work with user-defined properties for the table trigger.
- Click the Notes tab to view history associated with the table trigger and to add or view user notes.
- Click Close.
The table trigger is defined and the DB2 for LUW Table Trigger Editor closes.
Copyright © 2012 CA.
All rights reserved.
|
|