Data Transformation Engine ODBC Adapter Reference Guide

Chapter 4 - ODBC Adapter Commands Adapter Commands for a Source
ODBC Adapter Reference Guide
15
-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 a single quotation mark, which
is the Windows syntax. For non-Windows platforms, use two single quotation
marks followed by one single quotation mark and end with one single quotation
mark followed by two single quotation marks.
The Source in the Compiled Map is a Database
With Database/Query File Without Database/Query File
'[-MDQ mdq_file -DBNAME database_name ]
[-QUERY
query_name |-STMT SQL_stmt ]
[-FILE [
directory ]]
[-VAR
name = value …]
[-USER
username ]
[-PASSWORD
password ]
[-CCARD|-CSTMT [
number ]]
[-ROWCNT
row_count ]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]'
'-DBTYPE ODBC
-SOURCE datasource
-STMT
SQL_statement
[-FILE [
directory ]]
[-VAR
name = value …]
[-USER
user_ID ]
[-PASSWORD
password ]
[-CCARD|-CSTMT [
number ]]
[-ROWCNT
row_count ]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]'
The Source in the Compiled Map is Not a Database
With Database/Query File Without Database/Query File
'-MDQ mdq_file
-DBNAME database_name ]
-QUERY
query_name |-STMT SQL_stmt ]
[-FILE [
directory ]]
[-VAR
name =value]…
[-USER
username ]
[-PASSWORD
password ]
[-CCARD|-CSTMT [
number ]]
[-ROWCNT
row_count ]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]'
'-DBTYPE ODBC
-SOURCE
datasource
-STMT
SQL_statement
[-FILE [
directory ]]
[-USER
user_ID ]
[-PASSWORD
password ]
[-CCARD|-CSTMT [
number ]]
[-ROWCNT
row_count ]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]'