Data Transformation Engine Resource Adapter Reference Guide

Chapter 6 - Generating Type Trees Using mtsmaker List of Parameters
Resource Adapters Reference Guide
77
List of Parameters
The following table lists: the mtsmaker parameters that can be used for
generating type trees; the parameter syntax; and whether each one can be used
(√) with or without a database/query file.
Parameter Name Parameter Syntax
With
.mdq
Without
.mdq
Database Name
-B database_name
√
Data Source
ODBC and DB2
-D datasource
√
Oracle
-D connect_string
√
Sybase SQL Server
-D server\\database
√
Type Tree File
-F mtt_file_name
√ √
Stored Procedure Name
-G stored_procedure_name
√ √
Database/Query File
-M mdq_file
√
Category Type
-N type_name
√
Tree Script File
-O mts_file_name
√ √
Password
-P password
√
Query Name
-Q query_name
√
SQL Statement
-S " sql_statement "
√
Table Name
-T table_name
√ √
User ID
-U user_id
√
Variable Name
-V name = value
√ √
Format *
-X [F][O][T]
√ √
Database Adapter Type
-Z database_adapter_type
√
*The
O option of the Format parameter (-X) can be used only with the Oracle
adapter.
Note To access the list of mtsmaker parameters and the syntax for each parameter,
enter mtsmaker parameters –H or ? on the command line.