Data Transformation Engine SQL/MX Adapter Reference Guide

Adapter Commands for a Source Chapter 5 - Adapter Commands
SQL/MX Adapter Reference Guide
15
Adapter Commands for a Source
This summary shows the syntax of the adapter commands that can be used when
defining a data source using an .mdq file or without using one, including both the
required and optional adapter commands in the following situations:
♦ using a GET > Source > Command setting in the Map Designer and
Integration Flow Designer
♦ overriding a data source using the Input Source Override – Database execution
command (-
ID) using a RUN function or on the command line
♦ using a
DBLOOKUP, DBQUERY, or GET function in map or component rules
GET > Source > Command Setting
Use the Map Designer or Integration Flow Designer to specify Database as the
value for the GET > Source setting and enter the database adapter commands as
desired for the Command setting.
With Database/Query File Without Database/Query File
[-DBTYPE SQLMX]
[-STMT
SQL_statement ]
[-FILE [
directory ]]
[-VAR
name = value …]
[-CSTMT [
number ]]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]
-DBTYPE SQLMX
-STMT
SQL_statement
[-FILE [
directory ]]
[-VAR
name = value …]
[-CSTMT [
number ]]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]
-ID Execution Command
Use the Input Source Override - Database execution command (-ID) to designate a
database as the source or you can override one or more of the adapter command
settings or database definitions in a
RUN function or on the command line.
Note The following adapter commands are shown using one double quotation mark
followed by one single quotation mark and end with one single quotation mark
followed by one double quotation mark.