(Contents)(Previous)(Next)

Triggers

A Trigger is a procedure executed by the database server as soon as a DML statement is applied to a base table or a view table derived from it. Thus, the three trigger types INSERT, UPDATE, and DELETE are available; an UPDATE trigger call can be restricted to specific columns.

Relationships between a trigger and other objects:

1. Table Contains Trigger

2. Trigger Uses Module

1. A table can contain triggers; each trigger is assigned to exactly one table

(1-N[0]).

2. A trigger definition refers to exactly one module; a module can be used for defining a number of triggers (N[0]-1).

DOMAIN provides only informational functions for the defined triggers.

From the main menu, you can access any trigger list and then click on the toolbar button or select the Object / Design function to select the trigger and change to design mode. In design mode, the trigger is displayed on a cardfile card with its parameters and constraints from the table definition.

As with all objects, you can define or query a comment for each trigger in the trigger list.


(Contents)(Previous)(Next)