Data Transformation Engine Resource Adapter Reference Guide

Chapter 5 - Database-specific Adapter Information List of Commands
Resource Adapters Reference Guide
67
SQL Statement (-S or -STMT)
Use the SQL Statement adapter command (-STMT) either for a source or in a GET
function to specify an SQL statement or a call to a stored procedure using either
the database-independent or native call syntax to be executed. This execution will
provide the input data to a map.
-STMT
SQL_statement
Table Name (-TB or -TABLE)
Use the Table Name adapter command (-TABLE) to specify the table to which or
in which the map will insert or update data, respectively. Use this command either
for a target or in a
PUT function.
-TABLE
table_name
Note If the Table Name adapter command (-TABLE) is specified, it overrides the value
in the DatabaseQueryFile > Table output card setting.
Trace (-T or -TRACE)
Use the Trace adapter command (-TRACE) to produce a database trace file. Trace
information is recorded that details the database adapter activity. This command
can be used either for a source or target, or in a
DBLOOKUP, DBQUERY, GET, or
PUT function.
Note To produce a trace, you must specify the Trace adapter command (-TRACE) or
Trace Error adapter command (-TRACEERR). A database trace is not produced if
only map trace is enabled, as was true in previous versions of the database
adapters.