Data Transformation Engine ODBC Adapter Reference Guide

Chapter 4 - ODBC Adapter Commands Adapter Commands for a Source

ODBC Adapter Reference Guide

Data Source (-SOURCE)

Use the Data Source adapter command (-SOURCE) to specify the ODBC data source.

-SOURCE

datasource

Option Description

datasource

Specify the ODBC data source.

Adapter Commands for a Source

This summary shows the syntax of the adapter commands that can be used when

defining a data source using an .mdq file or without using an .mdq file, including

both the required and optional adapter commands in the following situations:

♦ using a GET > Source > Command setting in the Map Designer and

Integration Flow Designer

♦ overriding a data source using the Input Source Override – Database execution

command (-

ID) using a RUN function or on the command line

♦ using a

DBLOOKUP, DBQUERY, or GET function in map or component rules

GET > Source > Command Setting

Use the Map Designer or Integration Flow Designer to specify Database as the

value for the GET > Source setting and enter the database adapter commands as

desired for the Command setting.

With Database/Query File Without Database/Query File

[-DBTYPE ODBC]

[-SOURCE

datasource

]

[-STMT

SQL_statement

]

[-FILE [