Data Transformation Engine Resource Adapter Reference Guide

Chapter 5 - Database-specific Adapter Information List of Commands
Resource Adapters Reference Guide
58
Name Adapter Command Syntax
Source Target
DBLOOKUP
DBQUERY
GET PUT
Trace
-TRACE[+] [ full_path ]
√ √ √ √ √
Trace Error
-TRACEERR[+] [ full_path ]
√ √ √ √ √
Trigger (Oracle 8,
Microsoft SQL
Server 7 only)
-TRIG trigger_string
√
Update
-UPDATE [OFF|ONLY]
√ √
User ID
-USER user_ID
√ √ √ √ √
Variable
-VAR name = value…
√ √ √
* A card setting exists. Using the adapter command will override any value set in
the corresponding card setting. For examples, refer to Command Line Examples.
Audit (-A or -AUDIT)
Use the Audit adapter command (-AUDIT) to create a file that records the adapter
activity for each specified input and output card. This adapter command can be
specified for individual input and output cards on a card-by-card basis, or,
optionally, as a global audit that encompasses all database activity for the entire
map. This command can be used for a source or target, or in a
DBLOOKUP,
DBQUERY, GET, or PUT function. The default usage is to produce a file named
audit.dbl in the directory in which the map is located. Optionally, you can append
the audit information to an existing file or specify a name or the full pathname for
the file. For more information, refer to the Database Interface Designer Reference
Guide.
-AUDIT[G][+] [
full_pathname ]
Value Description
G
Activate a global audit for the entire map by specifying this
command for the first database card that will have database
activity. This records all database activity for all sources,
targets, and functions for all defined cards.
+
Append audit information to an existing file.
full_path
Specify the name of the audit file that can include the
directory pathname.