Data Transformation Engine Database Interface Designer Reference Guide

Chapter 3 - Database/query Files Printing Reports
Database Interface Designer Reference Guide
66
To generate a type tree from a query
1 In the Navigator, highlight the icon of the query from which you want to
generate a type tree.
2 From the Query menu, select Generate Tree.
or
In the Navigator, right-click the query and select Generate Tree.
The Generate Type Tree from Query dialog box appears, displaying the
name of the selected type tree.
3 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.
4 Specify the remaining options as desired. Refer to context-sensitive help for
field-specific information.
5 Click OK.
The Database Interface Designer and the Type Tree Maker produce a type tree
corresponding to the selected database query.
The generated type tree is represented in the Navigator with the query icon (
)
displayed next to the name.
Printing Reports
You can print reports including detailed information about each specified database
and query contained in an .mdq file. Reports contain information about the
databases and queries that you designate. They can also include the time when
the report was printed, the full path name of the .mdq file, the database
definition, and definitions of each query and stored procedure.
Note You can only specify one database at a time.