Previous Topic: Prerequisites for Generating RI TriggersNext Topic: Types of Referential Integrity Triggers


Generating Triggers

To generate triggers, use the Host Encyclopedia Construction Tools.

Follow these steps:

  1. Select the model name.
  2. Specify the target environment's operating system, DBMS, and language.
  3. Specify Referential Integrity Trigger target environment operating system, generated source language, database management system, and DB2 subsystem for package binds.
  4. Set the optional DB2 Bind Package defaults for Referential Integrity modules, or the model, or individual members.
  5. Specify the libraries for the source code, load modules, Database Request Modules (DBRMs) for DB2, installation control, and listings (optional).
  6. Set Dynamically Link RI Triggers flag. When you set this flag to Yes, verify that the RI TP Monitor and RI Trigger Name are set correctly.
  7. Generate all Referential Integrity triggers or selectively generate RI triggers.
  8. Install, that is compile and link edit, the generated RI triggers.

The following graphic illustrates the trigger generation process.

Trigger Generation Process