Physical Modeling › Materialized Query Tables › Define Materialized Query Table Triggers

Previous Topic: Attach a Materialized Query Table to a Script

Next Topic: Materialized Query Column

Define Materialized Query Table Triggers

Use the Materialized Query Table Trigger Editor to define the stored procedures that exist for a materialized query table in a DB2 LUW or DB2 z/OS physical model.

To define materialized query table triggers

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

    The Materialized Query Table Trigger Editor opens.

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

    Name

    Displays the materialized query table trigger name. You can change the trigger name in this field.

    Schema

    Specifies the schema for the materialized query table trigger. Select a schema from the drop-down list.

    Insert

    Specifies to execute the materialized query table trigger on INSERT.

    Update

    Specifies to execute the materialized query table trigger on UPDATE.

    Delete

    Specifies to execute the materialized query table trigger on DELETE.

    Fire

    Specifies when the materialized query table trigger is executed.

    Generate

    Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

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

    The materialized query table trigger is defined and the Materialized Query Table Trigger Editor closes.