Data Transformation Engine Database Interface Designer Reference Guide

Chapter 4 - Database Type Trees Table and Query Type Tree Structure
Database Interface Designer Reference Guide
86
An example of this definition follows.
The following example illustrates the appearance of the data before insertion into
the table.
Note In this example, the floating-point values are italicized because their actual values
would result in unprintable characters.
Gasket|103401|4|
1.99 |1718|<1718 bytes of binary data>
Widget|103402|4|
3.49 |0
|103403|4|
0| 1569 |<1569 bytes of binary data>
Gadget Pro|103404|4|
9.98 |2145|<2145 bytes of binary data>
DooDad|103405|0||0
Notice the following about the data in this example:
♦ In the first and fourth records (
Gasket and Gadget Pro), all components of
Row are present in the data, including the Sizeof value for the Unit_Price
and Picture columns.
♦ In the second record (
Widget), there is no value in the Picture column.
Therefore, the Sizeof value for the Picture column is zero.