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.