Data Transformation Engine SQL/MX Adapter Reference Guide

SQL/MX Adapter Reference Guide
6
Chapter 2 - Command Alias
Specify the NonStop SQL/MX adapter commands on the command line using an
execution command string or using the Platform API. You can also create a
command file, shell script, or batch file that contains the desired adapter
commands for map execution. For information about all of the options you can
use with the execution commands for adapters or how to create a command file,
refer to the Execution Commands Reference Guide.
For example, an existing data source (which is a file) can be overridden and
specified to be a database using the Input Source Override - Database execution
command (
-ID). Or, you can override an existing data target that is a table in one
database with a table in a different database using the Output Source Override -
Database execution command (
-OD). For information about all of the options to
use within these database execution commands, refer to the Execution Commands
Reference Guide.
The values specified using the Input Source Override - Database execution
command (
-ID) and the Output Source Override - Database execution command
(
-OD) can be used to designate a query or table to be used as the data source or
target, or to override one or more of the adapter commands of an existing
database definition as follows:
♦ using a database/query (.mdq) file
Specify the name of an .mdq file and the name of a particular database that
will override the appropriate adapter settings. In this usage, the .mdq file
must be available at map execution time. The values in the .mdq file will
override all values defined in the map.
♦ not using an .mdq file
Use a command string that includes all of the database adapter commands
necessary to specify the desired settings for a map. An .mdq file is not used.
For examples of various ways to use the database adapter commands on the
command line, refer to the database adapter-specific section in the Resource
Adapters Reference Guide.