Data Transformation Engine Database Interface Designer Reference Guide

Chapter 4 - Database Type Trees Table and Query Type Tree Structure
Database Interface Designer Reference Guide
82
♦ The formats of those group types defined as subtypes of the SizedGroup
category are defined in the same way as the format for the Row group type.
If the type tree has a delimited Row group format, the group types for the
binary columns are also defined as delimited groups with the pipe character (|)
as an infix delimiter. In this example, the Sizeof component is defined as
being required in the component list. However, the binary item type is optional
(with a range of 0:1), as shown in the preceding example.
Note You cannot generate a fixed Row group format type tree for a table or
query containing variable length binary data.
If the type tree has a fixed Row group format, the group types for the binary
columns are also defined as fixed groups. In this situation, both the Sizeof
component and the binary item type (TOTAL_CREDIT_AMT in the following
example) are required.
♦ In the group type component list, the Sizeof component has the Sized
attribute, indicating that the Sizeof item contains the size of the binary item
that follows it.
Note When mapping to a table or view containing binary columns, use the
SIZE function to assign the size of the binary data to the Sizeof data
item.
♦ The components for the Row type are the group types under the SizedGroup
category for the binary columns.