Data Transformation Engine Resource Adapter Reference Guide

Chapter 6 - Generating Type Trees Using mtsmaker List of Parameters
Resource Adapters Reference Guide
81
If using the following query from an mdq file, select * from BigTable where
Identifier = #ID# then specify the following option on the mtsmaker command
line:
-V
ID = 2
In this way, the query to be executed would be as follows:
select * from BigTable where Identifier = 2
Note that variable name values are read by default from the MDQ file, unless
overridden on the command line.
See the Database Interface Designer Guide for more information regarding the
definition of variables in SQL statements.
Format (-X)
Specify a format for the type tree to be generated. Do not use the default which is
delimited.
-X [F][O][T]
Option Description
F
Generate a fixed row format type tree.
O
(Oracle only) Generate a Mercator 1.4.x format type tree.
T
Generate a type tree with dates represented as text items. If
this option is not specified, the default is to represent dates as
date items.
Database Adapter Type (-Z)
Specify the database adapter type to which to connect.
-Z {ODBC|ORACLE|SQLSVR|SQLSVR7|OLEDB|SYBASE|DB2|DB2MVS|IFMX}
Option Description
ODBC
ODBC database adapter
ORACLE
Oracle database adapter