Data Transformation Engine Database Interface Designer Reference Guide

Chapter 3 - Database/query Files Generating Type Trees

Database Interface Designer Reference Guide

Field Description

Stored Procedures This list displays all of the stored procedures that have

been defined in this database. Select one or more from

this list.

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

File name This field displays a system-generated file name based

upon the database selection in the Navigator. The

default value is the database name with a type tree

extension (.mtt) and a default path.

To change any of this information, click

(browse).

Overwrite file This check box determines whether you want to replace

the existing type tree file (.mtt) upon saving it. The

default value is disabled.

Override type This check box determines whether to replace existing

types with matching, newly generated types and to add

any non-matching new types to the type tree file (.mtt).

This is useful when you want to add types for additional

stored procedures into an existing type tree. The default

value is enabled.