Data Transformation Engine Database Interface Designer Reference Guide

Chapter 3 - Database/query Files Generating Type Trees
Database Interface Designer Reference Guide
60
Field Description
Fixed Select this option to create rows of fixed size in the
generated type tree. There are certain situations in
which you would want to select Fixed.
♦ The query result contains a large number of rows
where each row consists of small, fixed-length fields.
In this situation, delimiters are unnecessary and they
also consume memory.
♦ You need to append fields in the output. This may be
true if multiple fields have some meaning when
concatenated together.
Delimiter This is the value for the delimiter to be used when
generating this type tree. For a list of available symbols,
click the browse button. The Symbols dialog box
appears, allowing you to select the desired value. The
default value is a pipe character (|).
Terminator This is the value for the terminator to be used when
generating this type tree. For a list of available symbols,
click the browse button. The Symbols dialog box
appears, allowing you to select the desired value. The
default value is <CR><LF>.
Release This is the value for the release character to be used
when generating this type tree. For a list of available
symbols, click the browse button. The Symbols dialog
box appears, allowing you to select the desired value.
The default value is an exclamation point (!).
Override Column
Definitions
(For ODBC only) This field is not available for message
queues.
Generate type
trees in Mercator
1.4.0 format
(For Oracle adapter only) This check box determines
whether you can generate type trees that are compatible
with Mercator Software Version 1.4.0 maps. You might
enable this functionality if you have legacy 1.4.0 maps
that you want to maintain for some reason. The default
value is disabled.
For more information about this field, refer to adapter-
specific documentation in each adapter reference guide.