Data Transformation Engine SQL/MX Adapter Reference Guide

Adapter Commands for a Source Chapter 5 - Adapter Commands
SQL/MX Adapter Reference Guide
16
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 SQLMX
-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 SQLMX
-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 SQLMX
[-CCARD|-CSTMT [number]]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]")