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

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.

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 source is a database

Database/query file (.mdq) No database/query file (.mdq) 
'[-MDQ DDNAME 
-DBNAME database_name]
[-QUERY query_name|-STMT SQL_stmt]
[-VAR name=value...]
[-CCARD|-CSTMT [number]]
[{-TRACE [file|ERROR]}]'
 
'-DBTYPE ODBC 
-STMT SQL_statement 
[-SOURCE datasource]
[-VAR name=value...]
[-CCARD|-CSTMT [number]]
[{-TRACE [file|ERROR]}]'

Scenario: compiled map source is not a database

Database/query file (.mdq) No database/query file (.mdq) 
'-MDQ DDNAME 
-DBNAME database_name]
-QUERY query_name|-STMT SQL_stmt]
[-VAR name=value...] 
[-CCARD|-CSTMT [number]]
[{-TRACE [file|ERROR]}]'
 
'-DBTYPE ODBC
-STMT SQL_statement
[-SOURCE datasource]
[-CCARD|-CSTMT [number]]
[{-TRACE [file|ERROR]}]'