Data Transformation Engine SQL/MX Adapter Reference Guide

SQL/MX Adapter Reference Guide

Chapter 5 - Adapter Commands

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

commands and their options.

Note For information about 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 Command

The following is an adapter command that contains SQL/MX-specific database

parameters. For a complete listing of all database adapter commands, refer to the

Resource Adapters Reference Guide.

♦ -DBTYPE

Database Adapter Type (-DBTYPE)

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

database adapter type.

-DBTYPE SQLMX

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).

Option Description

SQLMX

The database adapter type is SQL/MX.