Data Transformation Engine Database Interface Designer Reference Guide

Chapter 3 - Database/query Files Generating Type Trees
Database Interface Designer Reference Guide
55
Field Description
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.
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 (!).