Chapter 3 Defining rules and queries 59
Using the adapter rule helper utilities
The operators IN, =, NOT IN, or != can precede $KEYLIST$. (For the $KEYLIST$ syntax,
= is the same as IN, and != is the same as NOT IN.) $KEYLIST$ is expanded with a
series of
<$field$> <operator> <value> statements as shown in Table 3-15.
Row-level query syntax
You can only use the syntax described in this section in the query syntax for a row-
level query. Integration Engine supports update, response, and deletion row-level
queries. Row-level queries are defined on the Update Query sub tab of the Query
tab on the EIE:ARMappingInfo form.
SRC syntax ($SRC| <fieldname>$)
SRC (source) syntax is a special syntax for row-level queries. It allows you to have
values from the source row substituted into the query before the query is
compared against the target row. The query is applied to the target row rather than
the source and target rows. Examples are defined in Table 3-16.
Using the adapter rule helper utilities
The Database Field Menus Console is used for populating field menus which are
used when you create data mappings. The field menus allow you to choose the
fields from your external data store from a list instead of typing them manually.
You use the adapter rule helpers to create field menus for external data store tables.
The DB2, Oracle, and SQL Server rule helpers are used through the Database Field
Menus Console. XML Helper and File Helper are used through workflows. They
can also be run from a command line to populate fields in
.tbl and .xsd in the
EIE:VendorFieldNames form.
NOTE
All helper binaries are available in the <AIE install directory>\bin directories.
Table 3-15: KEYLIST syntax examples
Example Result
$KEY$ = $KEYLIST$
Indicates that all records matching the keys in
the
$KEYLIST$ are to be returned.
$KEY$ != $KEYLIST$
Indicates that all records not matching the keys
in the
$KEYLIST$ are to be returned.
Table 3-16: SRC syntax examples
Example Result
$LastModified$ <
$SRC|LastMod$
$LastModified$ < 05/23/07
(if LastMod is a field in the source database with
a value of 05/23/07)
