Data Format - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

Product
Parallel Transporter
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
ang1608578408836.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2516
lifecycle
previous
Product Category
Teradata Tools and Utilities
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.