Data Transformation Engine Database Interface Designer Reference Guide

Chapter 9 - Database Triggers Specifying Triggers on the Command Line
Database Interface Designer Reference Guide
143
Specifying Triggers on the Command Line
If a trigger specification for a query has not been defined in the Database Interface
Designer or if you want to override conditions that are already defined in a trigger
specification associated with a query, use the command line.
For more information about using the command line and specifying the Trigger
adapter command (
-TR), refer to the Resource Adapters Reference Guide.
Using the Integration Flow Designer to Enable Triggers
After you have defined the trigger using the Database Interface Designer and have
created an executable map using the Map Designer, use the Integration Flow
Designer to define a system containing the associated map component and to
enable the trigger for execution by the Event Server. For more information, refer
to the Integration Flow Designer Reference Guide.
To set the database source as a trigger
1 In the Integration Flow Designer, display the Event Server Settings dialog
box for the map you want to trigger.
2 Set the SourceEvent setting value to ON.
3 Click OK.
A trigger icon appears on the map component in the system diagram. When the
map component appears in expanded state, a trigger icon
also appears on
the upper-left corner of the input card, as shown in the following example.
The trigger icon provides a visual cue showing the inputs that serve as triggers.