Data Transformation Engine Database Interface Designer Reference Guide

Chapter 3 - Database/query Files Generating Type Trees

Database Interface Designer Reference Guide

Field Description

Tables/Views This list displays all of the queues that have been

defined in this database. Select one or more from this

list.

Note If the queue you want is not displayed in this list,

add it by right-clicking in the list, selecting

Insert, and typing the desired name.

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.

Row group format This list displays options to determine the row format in

the generated type tree. The default value is Delimited.

Delimited Select this option to create rows delimited with a pipe

character (|) or some other user-defined selection. This

is the preferred option if you are using large column

widths where the values may be smaller than the width

of the columns. The pipe character is the default

selection.