Data records
Data records are of fixed-length format and contain the data
to be exported. The maximum length a data record can be is 7,000
bytes. The length of a data record is the sum of the widths of the
data types that comprise the record. Use the following table to
calculate the widths of each data type.
Important:
You cannot export a table with a VARCHAR column whose maximum
allowable length is over 254.
Table 23. Data widths in encoded format data records Calculate the width of a particular data type by adding the
number of bytes in each column.
Data
type |
Null
indicator
|
Length field |
SO/SI |
Data |
Character |
2 |
|
|
Length in header
(LIH) |
Date |
2 |
|
|
LIH |
Floating point |
2 |
|
|
8 |
Integer |
2 |
|
|
LIH |
Small integer |
2 |
|
|
LIH |
Time |
2 |
|
|
LIH |
Time stamp |
2 |
|
|
LIH |
Decimal |
2 |
|
|
(Precision +
2) // 2 |
Graphic |
2 |
|
2 |
(LIH × 2) |
Variable character |
2 |
2 |
|
LIH |
Variable graphic |
2 |
2 |
2 |
(2 × LIH) |
Note:
The
LIH is the width given in the header record for that column. |
Every data record has two bytes of indicator information, which
can have the following values and corresponding meaning:
Value |
Meaning |
X'0000' |
The column contains valid data |
X'FFFF' |
The column contains a null value;
any data in the column is meaningless. |
X'FFFE' |
