Data Transformation Engine Resource Adapter Reference Guide

Chapter 5 - Database-specific Adapter Information List of Commands

Resource Adapters Reference Guide

Value Description

when_clause

[[

table.column_name1

]…]

This is an expression that will be

evaluated when the other events

have occurred. If this expression

evaluates to TRUE, the conditions of

the trigger specification are met and

the map is launched. If the

expression is not TRUE, the state is

restored as it was prior to any

events occurring.

This expression may contain any

SQL expressions that are valid for

the target database. If database

columns are referenced, the column

name must be qualified with the

table name and enclosed in square

brackets.

An example of specifying trigger events and conditions using the adapter

command follows:

-TR I ACCT_INFO | TRANSACTIONS D ACCT_INFO U ACCT_INFO

W [TRANSACTION.TRANS_TYPE]='PY'

This example would cause the following to occur:

Launch the map (that uses this query as a data source) when …

there is an insertion into the ACCT_INFO or TRANSACTIONS tables,

or when there is a deletion from the ACCT_INFO table,

or when ACCT_INFO is updated,

but only when a row exists in TRANSACTION with the column TRANS_TYPE set

to 'PY'

You cannot combine both

| and & in an event class (Insert into, Delete from, or

Update of) if more than two tables or columns are being combined. For example,

the following command is invalid:

-TR I TABLE1 & TABLE2 | TABLE3