Data Transformation Engine Database Interface Designer Reference Guide

Chapter 9 - Database Triggers Specifying a Combination of Different Event Classes
Database Interface Designer Reference Guide
141
Specifying AND or OR
Within the Insert into and Delete from event classes, you can define multiple
insert and delete events by specifying multiple tables. Similarly, you can define
multiple Update of events by specifying multiple table names.
Note Using the Delete from event class disables row-based triggering. However, you
can still define multiple Insert Into and Update of events using row-based
triggering.
When you specify multiple table names within an event class, you must also
specify how you want the condition within the event class to be met—either when
all of the events occur for all of the specified tables or when one event occurs on
any one entry in the list.
The options that dictate the condition(s) to be met when you set up multiple
events are:
Option Description
AND This option dictates that all of the specified events must occur (for
example, TableA AND TableB) for the condition to be met.
OR This option dictates that conditions are met when at least one event
occurs (for example, TableA OR TableB).
Specifying When
After specifying at least one Insert into, Delete from, or Update of event, you
can create an expression that must evaluate to true to satisfy the conditions of the
trigger specification. Enter an expression in the When field that will be evaluated
after the other events have occurred. If the When expression evaluates to true,
the conditions of the trigger specification are met and the map is run. If the When
expression is not true, the state is restored to what it was prior to the occurrence
of any events. When row-based triggering is used, all of the changed rows will be
batched together for subsequent processing after the event is re-triggered and the
When clause has been satisfied.