Data Transformation Engine ODBC Adapter Reference Guide

Chapter 4 - ODBC Adapter Commands Adapter Commands for a Target
ODBC Adapter Reference Guide
16
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
[-USER
username ]
[-PASSWORD
password ]
[-CCARD|-CSTMT [number]]
[-ROWCNT
row_count ]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]")
DBQUERY (" SQL_statement ",
"
-DBTYPE ODBC
-SOURCE
datasource
[-USER
username ]
[-PASSWORD
password ]
[-CCARD|-CSTMT [number]]
[-ROWCNT
row_count ]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [full_path]]")
GET Function
The GET function returns the data from the source adapter.
With Database/Query File Without Database/Query File
GET ("DB",
"-MDQ
mdq_file
-DBNAME
database_name
-QUERY
query_name |-STMT SQL_stmt
[-FILE [ directory ]]
[-VAR
name = value …]
[-USER
username ]
[-PASSWORD
password ]
[-CCARD|-CSTMT [number]]
[-ROWCNT
row_count ]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]")
GET "DB",
"-DBTYPE ODBC
-SOURCE
datasource
-STMT
SQL_stmt
[-FILE [
directory ]]
[-USER
username ]
[-PASSWORD
password ]
[-ROWCNT
row_count ]
[-CCARD|-CSTMT [number]]
[-AUDIT[G][+] [
full_path ]]
[{-TRACE|-TRACEERR}[+] [
full_path ]]")
Adapter Commands for a Target
This summary shows the syntax of the adapter commands that can be used when
defining a data target using an .mdq file or without using an .mdq file, including
both the required and optional adapter commands in the following situations:
♦ using a PUT > Target > Command setting in the Map Designer and
Integration Flow Designer
♦ overriding a data source using the Output Source Override – Database
execution override (-
OD) using a RUN function or on the command line
♦ using the
PUT function in map or component rules