Data Transformation Engine SQL/MP Adapter Reference Guide

Adapter Commands for a Source Chapter 5 - Adapter Commands
SQL/MP Adapter Reference Guide
16
-ID Execution Command
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.
Note The following adapter commands are shown using one double quotation mark
followed by one single quotation mark and end with one single quotation mark
followed by one double quotation mark.
The Source in the Compiled Map is a Database
With Database/Query File Without Database/Query File
"'[-MDQ mdq_file -DBNAME database_name ]
[-QUERY
query_name |-STMT SQL_stmt ]
[-FILE [
directory ]]
[-VAR
name = value …]
[-CCARD|-CSTMT [
number ]]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]'"
"'-DBTYPE SQLMP
-STMT
SQL_statement
[-FILE [
directory ]]
[-VAR
name = value …]
[-CCARD|-CSTMT [
number ]]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]'"
The Source in the Compiled Map is Not a Database
With Database/Query File Without Database/Query File
"'-MDQ mdq_file
-DBNAME database_name
-QUERY
query_name |-STMT SQL_stmt
[-FILE [
directory ]]
[-VAR
name =value]…
[-CCARD|-CSTMT [
number ]]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]'"
"'-DBTYPE SQLMP
-STMT
SQL_statement
[-FILE [
directory ]]
[-CCARD|-CSTMT [
number ]]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]'"
DBLOOKUP or DBQUERY Functions
The DBLOOKUP and DBQUERY functions can be used in component rules in the
Type Designer and map rules in the Map Designer when creating a map that can
be used with a database.
With Database/Query File Without Database/Query File
DBLOOKUP (" SQL_statement ",
"-MDQ
mdq_file
-DBNAME
database_name
[-CCARD|-CSTMT [number]]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]")
DBQUERY ("
SQL_statement ",
"-DBTYPE SQLMP
[-CCARD|-CSTMT [number]]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]")