Neoview Database Administrator's Guide (R2.2)

3. Right-click the table for which you want to create a trigger and select Create Trigger to start
the Create Trigger Wizard.
In this example, suppose we have a database to record prescriptions. There are two tables:
prescriptions lists prescriptions for each patient, and generic_drugs lists generic
equivalents for brand name drugs. Before a prescription record is inserted, this trigger
looks up the drug in generic_drugs before the prescription record is inserted. If the
prescribed drug is found, a generic drug is substituted and the instructions in the
prescription record are updated to indicate this.
4. Enter a name for the trigger and then click Next:
5. Define the time, event, and column or columns for the trigger, then click Next:
6. Define aliases and granularity for the trigger and click Next:
54 Managing Database Objects