Data Transformation Engine Resource Adapter Reference Guide

Chapter 5 - Database-specific Adapter Information List of Commands
Resource Adapters Reference Guide
63
Data Source (-DS or -SOURCE)
Use the Data Source adapter command (-SOURCE) to specify the name of the
ODBC, Microsoft SQL Server, Sybase SQL Server, DB2, or Informix data source.
This command can be used for a source or target, or in a
DBLOOKUP, DBQUERY,
GET, or PUT function.
-SOURCE
datasource | server\\database
Value Description
datasource
Specify the ODBC, DB2 (Windows/UNIX), or
Informix data source.
server\\database
Specify the Microsoft SQL Server or Sybase SQL
Server data source.
Database/Query File (-M or -MDQ)
Use the Database/Query File adapter command (-MDQ) to specify the name of the
.mdq file that contains the database definition for the database to be used (as
specified using the -DN adapter command). This Database/Query File adapter
command can be used for a source or target, or in a
DBLOOKUP, DBQUERY, GET, or
PUT function.
-MDQ
mdq_file
When this adapter command is used, the .mdq file must be available at map
execution time. Also, if the .mdq file is not in the same directory as the compiled
map file, or when running under the Event Server, the full pathname is required.
Note If the Database/Query File adapter command (-MDQ) is specified, it overrides the
value in the DatabaseQueryFile > File setting.
File (-F or -FILE)
Use the File adapter command (-FILE) for database sources or in a GET function
to write the retrieved data to a temporary file that is read by either the Command
Server or Event Server. This is useful for situations in which the amount of data
retrieved by the adapter is large, possibly resulting in high memory consumption.
By default (that is, without this command), data is passed between the adapter
and the database server in memory. The default specification for this adapter