Data Transformation Engine Database Interface Designer Reference Guide

Chapter 3 - Database/query Files Generating Type Trees
Database Interface Designer Reference Guide
62
4 To create a new type tree, in the File name field, specify the path and name
(with an .mtt extension).
or
Click the browse button to select a type tree from the Save As dialog box.
Highlight it and click OK.
5 Specify the remaining options as desired. Refer to context-sensitive help for
field-specific information.
6 Click Generate.
The Database Interface Designer and the Type Tree Maker produce a type tree
corresponding to the selected queue(s).
Note Type trees generated from queues are not graphically represented in the
Navigator.
From a Query
When generating a type tree from a query, information is used from your
database and from the Database Interface Designer to create the type tree. If you
change the definition of your query in the Database Interface Designer or edit
that database definition, you must generate a new type tree to reflect the new
information.
When attempting to generate a type tree, if your query is incorrectly specified, an
error message from your database is received and a message displays, indicating
that the column definitions for that query could not be accessed. In this scenario,
a type tree is not generated.
Note Generating a type tree provides a way to test the syntax of your SELECT
statement. If you can successfully generate a type tree from a query, you know
that the query has valid syntax.
An example of the Generate Type Trees From Query dialog box follows, along
with a table describing its fields and their descriptions.