Data Transformation Engine ODBC Adapter Reference Guide

ODBC Adapter Reference Guide

Chapter 4 - ODBC Adapter Commands

This chapter describes the functions and usage of the ODBC adapter commands

and their options.

Note For information about command syntax notation, refer to Getting Started.

Adapter Command Summary

The following is a summary of the adapter commands that can be used to specify

data sources and targets. The applicability of many of the commands depends

upon whether you are specifying a source or target, whether a database/query file

(.mdq) is used, and the situations in which the usage of the command applies.

Adapter commands can be used in GET > Source > Command or PUT >

Target > Command settings in the Map Designer and Integration Flow Designer,

using

GET, PUT, DBLOOKUP, or DBQUERY function calls, or overriding a data

source or target using execution commands in a

RUN function or on the command

line.

Adapter-specific Commands

The following section lists and describes those adapter commands that are ODBC-

specific database parameters. For a complete listing of all database adapter

commands, refer to the Resource Adapters Reference Guide.

♦ -DBTYPE

♦ -ROWCNT

♦ -SOURCE