Data Transformation Engine Database Interface Designer Reference Guide

Chapter 3 - Database/query Files Generating Type Trees
Database Interface Designer Reference Guide
47
(
-ID). For more information about how to specify values for these variables at run
time, refer to the Resource Adapters Reference Guide.
Generating Type Trees
Use the Database Interface Designer to generate a type tree from a table, query,
stored procedure, or message queue associated with a particular database. A type
tree generated using the Database Interface Designer contains a type for the
table, query, stored procedure, or message, as well as a row type and types for
each column in that table, query, stored procedure, or message.
Note As an alternative, use mtsmaker on non Windows-based platforms to generate
type trees when you cannot use the Database Interface Designer. For more
information about using mtsmaker, refer to the Resource Adapters Reference
Guide.
Refer to the following sections for more information about how to generate a type
tree using the Database Interface Designer:
♦ from a table or view
♦ from a stored procedure
♦ from a message queue
♦ from a query
From a Table or View
When you generate a type tree for a table or view, information from your
database and from the Database Interface Designer is used to create a type tree
file (.mtt). If you change your database table definition or edit the database
definition in the Database Interface Designer, you must generate a new type tree
to reflect the new information.
Note Generated type trees may differ when generated using different database
adapters. For example, a date field may be represented differently by different
databases. For this reason, use the same adapter type that will be used at run
time to generate the type tree with the Database Interface Designer. Or, if you
use ODBC, use the Column Attributes Override dialog box that is described in
the Resource Adapters Reference Guide.