Data Transformation Engine SQL/MX Adapter Reference Guide

Adapter Commands for a Target Chapter 5 - Adapter Commands
SQL/MX Adapter Reference Guide
18
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 SQLMX]
[-TABLE
table_name ]
[-CSTMT [
number ]]
[-DELETE]
[-UPDATE [OFF|ONLY]]
[-BADDATA[+]
full_path ]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]
-DBTYPE SQLMX
-TABLE
table_name
[-CSTMT [
number ]]
[-DELETE]
[-UPDATE [OFF|ONLY]]
[-BADDATA[+]
full_path ]
[-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 the non-Windows standard of
one double quotation mark followed by one single quotation mark and end with
one single quotation mark followed by one double 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 ]
[-TABLE
table_name ]
[-CCARD|-CSTMT [
number ]]
[-DELETE]
[-UPDATE [OFF|ONLY]]
[-BADDATA[+]
full_path ]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]'"
"'-DBTYPE SQLMX
-TABLE
table_name
[-CCARD|-CSTMT [
number ]]
[-DELETE]
[-UPDATE [OFF|ONLY]]
[-BADDATA[+]
full_path ]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]'"