Data Transformation Engine Database Interface Designer Reference Guide

Chapter 4 - Database Type Trees Table and Query Type Tree Structure
Database Interface Designer Reference Guide
81
A category called SizedGroup is added to the tree (as indicated in the example
that follows). This category has an item subtype called Sizeof and group subtypes
with the same names as the item types for each binary column.
The following changes are made to the type tree to account for columns
representing binary data:
♦ Two variable length binary items (TOTAL_CREDIT_AMT and
TOTAL_DEBIT_AMT) are created as subtypes of the Column type to
represent the value of the two binary type columns.
♦ The Sizeof item is a subtype of the SizedGroup category and is defined as a
character integer item.
♦ Also, as a subtype of the SizedGroup category, two groups given the same
name as the binary column type are created, each group including two
components (Sizeof and either TOTAL_CREDIT_AMT or
TOTAL_DEBIT_AMT). The first component of each group is the Sizeof item;
the second, the variable length binary item (either ).