Data Transformation Engine SQL/MP Adapter Reference Guide

SQL/MP Adapter Reference Guide

Chapter 5 - Adapter Commands

This chapter describes the functions and usage of the NonStop SQL/MP adapter

commands and their options.

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

Adapter Command Summary

This chapter presents 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 an .mdq file

is used, and the situations in which the usage of this 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 Command

The following is an adapter command that contains NonStop SQL/MP-specific

database parameters. For a complete listing of the adapter commands that can be

used by all of the database-specific adapters, refer to the Resource Adapters

Reference Guide.

♦ -DBTYPE

Database Adapter Type (-DBTYPE)

Use the Database Adapter Type adapter command (-DBTYPE) to specify the

database-specific adapter type.

-DBTYPE SQLMP

Note This command must be specified if the original card is not a database and

no database is specified using the Database/Query adapter command

(-MDQ) and the Database Name adapter command (-DBNAME).