The internal format of each output record must conform to the specified schema.
The FastExport OUTMOD Adapter operator requires each field of the output record to be of a specified length. When no length is specified, the operator assumes the conventional default length.
The FastExport OUTMOD Adapter operator supports both fixed- and variable-length output records.
For records with a two-column schema such as:
( COL1 INTEGER, COL2 VARCHAR(10));
each record comprises:
- A four-byte integer, because 4 is the INTEGER length
- A two-byte length indicator for the VARCHAR field
- The CHAR data of the length indicated in the two-byte length indicator field
The following examples show the byte order when running Teradata PT on an Intel processor.
- If, for example, the integer has a decimal value of 100 and the VARCHAR is ASCII '12345', then the output record appears in hexadecimal notation as:
X'64 00 00 00 05 00 31 32 33 34 35'
- If the data in the output record is in indicator mode, there is a single preceding indicator byte:
X'00 64 00 00 00 05 00 31 32 33 34 35'