Data Transformation Engine Resource Adapter Reference Guide

Chapter 5 - Database-specific Adapter Information List of Commands

Resource Adapters Reference Guide

command is for the temporary file to be created in the same directory as the map.

The temporary file is then deleted after the map completes.

-FILE [

directory

Specify the directory in which the temporary file should be

created.

Global Transaction Management (-GTX)

Use the Global Transaction adapter command (-GTX) to indicate that the

operations on a card (whether input or output) should be processed within a

global transaction.

Note This command is available only for the Oracle 8, Oracle AQ, and Microsoft SQL

Server 7 database adapters.

-GTX

For more information about global transaction management, refer to the Global

Transaction Management Reference Guide.

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 with the

-DBNAME 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_name

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, the full pathname is required.

Note If the Database/Query File adapter command (-MDQ) is specified, it overrides the

value in the GET > Source > DatabaseQueryFile > File setting.