DB2® (z/OS®) Adapter database execution command (output source override)

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.

The 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.

Scenario: compiled map target is a database

Database/query file (.mdq) No database/query file (.mdq) 
'[-MDQ DDNAME -DBNAME database_name]
[-TABLE table_name]
[-CCARD|-CSTMT [number]]
[-DELETE]
[-UPDATE [OFF|ONLY]] 
[{-TRACE [file|ERROR]}]'
 
'-DBTYPE ODBC   
-TABLE table_name 
[-SOURCE datasource]
[-CCARD|-CSTMT [number]]
[-DELETE]
[-UPDATE [OFF|ONLY]]
[{-TRACE [file|ERROR]}]'

Scenario: compiled map target is not a database

Database/query file (.mdq) No database/query file (.mdq) 
'-MDQ DDNAME  
-DBNAME database_name 
-TABLE table_name 
[-CCARD|-CSTMT [number]]
[-DELETE]
[-UPDATE [OFF|ONLY]]
[{-TRACE [file|ERROR]}]'
 
'-DBTYPE ODBC 
-TABLE table_name 
[-SOURCE datasource]
[-CCARD|-CSTMT [number]]
[-DELETE]
[-UPDATE [OFF|ONLY]] 
[{-TRACE [file|ERROR]}]'