Physical Modeling › DB2 LUW Property Editors › Define a DB2 LUW View Trigger

Define a DB2 LUW View Trigger

Use the View Trigger Editor to define the triggers that exist for a view in a DB2 LUW physical model.

To define a DB2 LUW view trigger

1. Right-click the view for which you want to define a trigger and click Trigger Properties.

   The DB2 for LUW View Trigger Editor opens.

2. Select the view 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 view trigger. Use the Enter filter text text box to filter a large list of view triggers to locate the one that you want to define.

   Name

   Displays the view trigger name. You can change the trigger name in this field.

   Schema

   Specifies the schema for the view trigger. Select a schema from the drop-down list.

   Insert

   Specifies to execute the view trigger on INSERT.

   Update

   Specifies to execute the view trigger on UPDATE.

   Delete

   Specifies to execute the view trigger on DELETE.

   Fire

   Specifies when the view trigger is executed.

   Replace

   Specifies to use the REPLACE syntax for the view trigger.

   Generate

   Specifies whether or not to generate DDL for this object during Forward Engineering.

3. Click the General tab and define properties and referential integrity constraints.
4. Click the Code tab to define the trigger body for the view trigger.
5. Click the Expanded tab to view expanded code for the view trigger.
6. Click the Comment tab and enter any comments that you want to associate with the view trigger.
7. Click the UDP tab to work with user-defined properties for the view trigger.
8. Click the Notes tab to view history associated with the view trigger and to add or view user notes.
9. Click Close.

   The view trigger is defined and the DB2 for LUW View Trigger Editor closes.