Previous Topic: Define DB2 LUW XML IndexesNext Topic: Define a DB2 LUW Dimension Group

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

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

    The DB2 for LUW Table Trigger Editor opens.

  2. Select the table trigger in the Navigation Grid that you want to define and work with the following options:

    Note: Click New New icon in property editors to create a new object 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.

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

    The table trigger is defined and the DB2 for LUW Table Trigger Editor closes.