Data Transformation Engine Database Interface Designer Reference Guide

Chapter 4 - Database Type Trees Table and Query Type Tree Structure
Database Interface Designer Reference Guide
78
Fixed Row Group Format
If you select Fixed as the value in the Row group format list in either the
Generate Type Tree from Tables dialog box or the Generate Type Tree from
Query dialog box, the Properties window in the generated type tree indicates
that the Row type is an explicit group defined as having a fixed syntax. As a
result of this selection, you can specify the Terminator. (The default value is
None.) An example follows.
Each component of Row is a type representing a column. These components
appear in the component list in the same sequence as they appear in the query or
table, as opposed to the type tree, which lists them in alphabetical order. In a
fixed Row, each of the columns is defined as required within the Row and is
automatically assigned a range of (1:1) for each column component.
Note Although the optional range specification (0:1) and any other range specification
do appear next to the column name in any Component list, the required range
specification (1:1) does not appear, even if you enter it in the rule bar.
List of required
components