Data Transformation Engine ODBC Adapter Reference Guide

Chapter 4 - ODBC Adapter Commands Adapter Commands for a Target
ODBC Adapter Reference Guide
17
PUT > Target > Command Setting
Use the Map Designer or the Integration Flow Designer to specify Database as
the value for the PUT > Target setting and enter the adapter commands as
desired for the Command setting.
With Database/Query File Without Database/Query File
[-DBTYPE ODBC]
[-SOURCE
datasource ]
[-PROC
procedure_name |-TABLE table_name ]
[-USER
user_ID ]
[-PASSWORD
password ]
[-CSTMT [
number ]]
[-DELETE]
[-UPDATE [OFF|ONLY]]
[-BADDATA
[+] full_path ]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]
-DBTYPE ODBC
-SOURCE
datasource
-PROC
procedure_name |-TABLE table_name
[-USER
user_ID ]
[-PASSWORD
password ]
[-CSTMT [
number ]]
[-DELETE]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]
-OD Execution Command
Use the Output Source Override - Database execution command (-OD) to
designate a database as a target 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 Target in the Compiled Map is a Database
With Database/Query File Without Database/Query File
'[-MDQ mdq_file -DBNAME database_name ]
[-PROC
procedure_name |-TABLE table_name ]
[-USER
username ]
[-PASSWORD
password ]
[-CCARD|-CSTMT [
number ]]
[-DELETE]
[-UPDATE [OFF|ONLY]]
[-BADDATA[+]
full_path ]
'-DBTYPE ODBC
-SOURCE
datasource
-PROC
procedure_name |-TABLE table_name
[-USER
username ]
[-PASSWORD
password ]
[-CCARD|-CSTMT [
number ]]
[-DELETE]
[-UPDATE [OFF|ONLY]]