Data Transformation Engine Resource Adapter Reference Guide

Chapter 6 - Generating Type Trees Using mtsmaker Generating a Tree Script
Resource Adapters Reference Guide
74
Generating a Tree Script
When using mtsmaker, tree scripts can be created in either of two modes:
♦ by using a database/query file (.mdq)
♦ by not using an .mdq file
Control how you want the tree script file to be generated by specifying various
mtsmaker parameters.
Using mtsmaker with a Database/Query File
You can use a database/query file (.mdq) that was created using the Database
Interface Designer and transfer it, in binary mode, to the system hosting your
database. The .mdq file is then used as a source of information about a particular
query, database, or stored procedure.
To generate a tree script file (.mts) for a database query, specify the following
mtsmaker parameters:
Note For specific information about each mtsmaker parameter, refer to the List of
Parameters.
mtsmaker -M mdq_file
-Q query_name [-B database_name ]
-F mtt_file_name
-O mts_file_name
[-X {F|O|T|FOT}]
To generate a tree script file (.mts) for a table, view, or stored procedure, specify
the following mtsmaker parameters:
mtsmaker -M mdq_file
-B database_name
-T table_name |-G stored_procedure_name
-F mtt_file_name
-O mts_file_name
[-X {F|O|T|FOT}]