Data Transformation Engine Resource Adapter Reference Guide

Chapter 6 - Generating Type Trees Using mtsmaker General Parameter Rules
Resource Adapters Reference Guide
76
Example of Using mtsmaker Without an .mdq File
The following is an example of generating a tree script for a query without using a
database/query file and specifying an Oracle connect string with the Data Source
parameter (
–D).
Note The -D parameter can also be used to specify a data source for ODBC, Sybase
SQL Server, or DB2, as appropriate.
mtsmaker -s "select * from AddressList" -u yourid -p password
-z oracle -d "oracle connect string" -o addlist.mts
-f maillist.mtt -n adddata
Note As part of the SQL Statement parameter (-s) format, the SELECT statement must
be enclosed in a double quotation mark.
General Parameter Rules
To properly enter mtsmaker parameters, you must observe the correct syntax,
as well as follow these general rules:
♦ Each parameter must begin with a hyphen (for example,
-X).
♦ All parameters can be either upper or lower case, but cannot be mixed case.
♦ A space is required between the parameter and its value. Refer to the following
example:
-Z oracle
♦ The order of parameters is unimportant.
♦ If you do not specify all required parameters, mtsmaker prompts for any
missing information. The displayed parameter prompts depend upon the mode
in which you are operating, whether using a database/query file or not.