17.00 - Data Format - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

prodname
Parallel Transporter
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2516-220K
The Teradata PT PutRow and GetRow methods currently only support the indicator-mode input data format:
  • A variable-length indicator bytes field
  • A variable-length input data field

The positions of the indicator bits correspond to the fields of the loading and exporting row. There is one bit for each column in the table. The first bit in the first byte is the indicator for the first field in the record. If an indicator bit is set to one, the database nulls the corresponding field when the record is loaded. If the indicator bit is set to zero, the database loads the data specified for that field.

For example, when there are less than 9 columns, there is a 1-byte indicator-byte length. Between 9 and 16 columns, there is a 2-byte indicator-byte length. There is a 3-byte indicator-byte length between 17 and 24 columns, etc.

Bytes Illustrating Indicator-Mode Input Data Format

Find more information about the indicator byte in Teradata® FastLoad Reference, B035-2411. See Related Documentation.

When using the Teradata PT PutBuffer function with the Load driver, the input data can be in indicator mode or in non-indicator mode format. When using the PutBuffer function with the Update or Stream driver, the input data must be in indicator mode format.