Data Transformation Engine Resource Adapter Reference Guide

Chapter 6 - Generating Type Trees Using mtsmaker Generating a Tree Script
Resource Adapters Reference Guide
75
Example of Using mtsmaker with an .mdq File
The following is an example of using mtsmaker with a database/query file to
generate a tree script file for a table:
mtsmaker -m mdqfile.mdq -b mydbase -t mytable -f tree.mtt
-o mtsfile.mts –x f
Using mtsmaker without a Database/Query File
Type trees can be generated without using database/query files. However, you
must specify all of the necessary information so that mtsmaker can generate the
tree scripts for queries, tables, views, or stored procedures.
To generate a tree script file (.mts) for a query, specify the following mtsmaker
parameters:
mtsmaker -S " sql_select_statement "
-Z database_adapter_type
[-U user_id ]
[-P password ]
[-D { datasource | connect_string | server\\database }]
-O mts_file_name
-F mtt_file_name
- N type_name
[-X [F][O][T]]
To generate a tree script file for a table, view, or stored procedure, specify the
following mtsmaker parameters:
mtsmaker -T table_name |-G stored_procedure_name
-Z database_adapter_type
[-U user_id ]
[-P password ]
[-D {
datasource | connect_string | server\\database }]
-O mts_file_name
-F mtt_file_name
-N type_name
[-X [F][O][T]]