Data Transformation Engine Database Interface Designer Reference Guide

Chapter 3 - Database/query Files Generating Type Trees

Database Interface Designer Reference Guide

To generate a type tree from a stored procedure

1 In the Navigator, highlight the icon of the database containing one or more

stored procedures from which you want to generate a type tree.

2 From the Database menu, click Generate Tree From > Procedure.

In the Navigator, right-click the database and select Generate Tree From >

Procedure.

The Generate Type Tree from Stored Procedures dialog box appears,

including a list of stored procedures.

3 If you need to add a stored procedure because it is not displayed in the Stored

Procedures list, you must insert it following the instructions provided in the

Note below.

If you see one or more stored procedures in the Stored Procedures list that

you want to select, if it is one, select it; if it is multiple procedures, press either

Shift or Ctrl and click the desired stored procedures.

Note The list of stored procedures includes stand-alone procedures by default.

(Procedures that are parts of a package are not listed.) If you need a

procedure that is part of a package (whether this functionality is

available is dependent upon your database), you may need to insert it

into this list before selecting it. To insert a packaged stored procedure,

right-click in the list, select Insert, and type the desired name. Use the

following format:

schema.package.procedure

4 To create a new type tree, in the File name field, specify the path and name

(with an .mtt extension).

Click

(browse) 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 Type Tree Maker produce a type tree

corresponding to the selected stored procedure(s).