Data Transformation Engine SQL/MP Adapter Reference Guide

Adapter Commands for a Source Chapter 5 - Adapter Commands

SQL/MP Adapter Reference Guide

Option Description

SQLMP

The database-specific adapter type is NonStop SQL/MP.

Adapter Commands for a Source

This summary shows the syntax of the adapter commands that can be used when

defining a data source using an .mdq file or without using one, including both the

required and optional adapter commands in the following situations:

♦ using the GET > Source > Command setting in the Map Designer and

Integration Flow Designer

♦ overriding a data source using the Input Source Override – Database execution

command (-

ID) using a RUN function or on the command line

♦ using a

DBLOOKUP, DBQUERY, or GET function in map or component rules

GET > Source > Command Setting

Use the Map Designer or Integration Flow Designer to specify Database as the

value for the Source setting and enter the database-specific adapter commands

as desired for the Command setting.

With Database/Query File Without Database/Query File

[-DBTYPE SQLMP]

[-STMT

SQL_statement

]

[-FILE [