Data Transformation Engine SQL/MP Adapter Reference Guide

Adapter Commands for a Target Chapter 5 - Adapter Commands

SQL/MP Adapter Reference Guide

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

]]

[-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 one, including both the

required and optional adapter commands in the following situations:

♦ using the PUT > Target > Command setting in the Map Designer and

Integration Flow Designer

♦ overriding a data source using the Output Source Override – Database

execution command (

-OD) using a RUN function or on the command line

♦ using the

PUT function in map or component rules