Database execution command: input source override (-ID)

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):

'[-MDQ mdq_file 
-DBNAME database_name]
[-CACHE]
[-QUERY query_name|-STMT SQL_stmt]
[-FILE [directory]]
[-VAR name=value...]
[-TRIG trigger_string]
[-USER username]
[-PASSWORD password]
[-CCARD|-CSTMT [number]]
[-ROWCNT row_count]
[-GTX]
[-AUDIT[G][+] [full_path]] 
[{-TRACE|-TRACEERR}[+]
[full_path]]'

No database/query file (.mdq):

'-DBTYPE ORACLE
[-CACHE]
-STMT SQL_statement
[-CONNECT connect_string]
[-FILE [directory]]
[-VAR name=value…]
[-TRIG trigger_string]
[-USER user_ID]
[-PASSWORD password]
[-CCARD|-CSTMT [number]]
[-ROWCNT row_count]
[-GTX]
[-AUDIT[G][+] [full_path]]
[{-TRACE|-TRACEERR}[+] [full_path]]'

Scenario: compiled map source is not a database

Database/query file (.mdq):

'[-MDQ mdq_file
-DBNAME database_name]
[-CACHE]
[-QUERY query_name|-STMT SQL_stmt]
[-FILE [directory]]
[-VAR name=value…]
[-TRIG trigger_string]
[-USER username]
[-PASSWORD password]
[-CCARD|-CSTMT [number]]
[-ROWCNT row_count]
[-GTX]
[-AUDIT[G][+] [full_path]]
[{-TRACE|-TRACEERR}[+] [full_path]]'

No database/query file (.mdq):

'-DBTYPE ORACLE
[-CACHE]
-STMT SQL_statement
[-CONNECT connect_string]
[-FILE [directory]]
[-TRIG trigger_string]
[-USER user_ID]
[-PASSWORD password]
[-CCARD|-CSTMT [number]]
[-ROWCNT row_count]
[-GTX]
[-AUDIT[G][+] [full_path]]
[{-TRACE|-TRACEERR}[+] [full_path]]'