Data Transformation Engine Resource Adapter Reference Guide

Chapter 6 - Generating Type Trees Using mtsmaker List of Parameters
Resource Adapters Reference Guide
80
SQL Statement (-S)
Specify an SQL statement or a call to a stored procedure using either the
database-independent or native call syntax that is passed to the database
management system to determine the content and format of the database output.
This statement should be the same as the statement you are using to generate
input for your map. However, you may exclude SQL WHERE clauses because they
do not affect the format of the result.
-S "
sql_statement "
Note The SQL statement must be enclosed in double quotation marks.
Table Name (-T)
Specify the name of the table (or the view that can be updated) for which you
want to generate the tree script file (.mts).
-T
table_name
User ID (-U)
Specify the user ID to use to connect to the data source. This parameter may be
required based upon your database security.
-U
user_id
Variable Name (-V)
Specify this parameter whenever needing variable name substitution in a SQL
query that is contained in an MDQ file.
-V
name = value
whereby:
name is the name of the variable in the SQL query.
value is the value that should be substituted.
Note The equal sign (=) must be included to properly associate the substituted value
with the variable name.
For example: