Data Transformation Engine Resource Adapter Reference Guide

Chapter 5 - Database-specific Adapter Information List of Commands
Resource Adapters Reference Guide
69
Trigger (-TR or -TRIG)
Note This command is available only for the Oracle 8 and Microsoft SQL Server 7
database adapters.
Use the Trigger adapter command (
-TRIG) for a source to specify the trigger
string for a trigger specification. For more information about specifying database
triggers, refer to the Database Interface Designer Reference Guide.
The Trigger adapter command (
-TRIG) can be used as a trigger specification for a
query that has no defined trigger in the Database Interface Designer. It can also
be used to override conditions that are already defined in a trigger specification
associated with a query.
-TRIG {[R] [I
tablename1 [{&||} tablename2 ]…]
[D
tablename1 [{&||} tablename2 ]…
[U
tablename1 [{&||} tablename2 ]…]}
[W
when_clause [[ table.column_name1 ]]…]
Note The pipe character (|) is used to represent OR and the ampersand character (&) is
used to represent AND. The combination of characters &| represents an AND/OR
statement. The value inserted as the when_clause must be a valid SQL syntax
with table.column_name enclosed in square brackets.
Value Description
R
This indicates that row-based
triggering is being used as opposed
to table-based.
I tablename1 [{&||} tablename2 ]…
The insertion of rows into the
specified table(s) serves as an input
event trigger to the map using this
query as a source.
D
tablename1 [{&||} tablename2 ]…
The deletion of rows from the
specified table(s) serves as an input
event trigger to the map using this
query as a source.
U tablename1
[{&||} tablename2 ]…
Updating values in the specified
column(s) serves as an input event
trigger to the map using this query
as a source.