Data Transformation Engine Database Interface Designer Reference Guide

Chapter 4 - Database Type Trees Table and Query Type Tree Structure

Database Interface Designer Reference Guide

Delimited Row Group Format

If you select Delimited as the value in the Row group format list in either the

Generate Type Tree from Tables window or the Generate Type Tree from

Query window, the Properties window in the generated type tree indicates that

the Group Subclass > Format is an explicit group defined as having a delimited

syntax. In the Properties window of the Type Designer, you can specify the

Delimiter, Initiator, Terminator, and Release options. The default values are

|, None, <CR><LF>, and !, respectively. 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

delimited Row, each of the columns is defined as optional within the Row by

specifying a range of (0:1) for each column component.

List of optional

components (with

ranges of 0:1)