Returned Data Format - Access Module

Teradata Tools and Utilities Access Module Reference

Product
Access Module
Release Number
16.10
Published
July 2017
Language
English (United States)
Last Update
2019-03-27
dita:mapPath
amk1499705096540.ditamap
dita:ditavalPath
amk1499705096540.ditaval
dita:id
B035-2425
lifecycle
previous
Product Category
Teradata Tools and Utilities
The Teradata Access Module for OLE DB provides data to and receives data from Teradata utilities in pmIDFBin1Plus format with indicator mode bits. In this format, each row consists of the following:
  • A 2-byte record-length indicator specifying the length of everything in the row except the record-length indicator
  • An indicator bit for each field specifying whether the field has data or is NULL
  • The actual row data
  • A new-line character signifying the end-of-record
When creating job scripts, be sure to specify the following:
  • INDICATORS in the BEGIN LOADING command of a FastLoad job script
  • MODE INDICATOR in the .EXPORT command of a FastExport job script
  • INDICATORS in the .LAYOUT command of a MultiLoad job script
  • INDICATORS in the .LAYOUT command of a TPump job script
  • INDICDATA in the .IMPORT command of a BTEQ load job script
  • INDICDATA in the .EXPORT command of the BTEQ export job script
  • Yes in the IndicatorMode attribute value and Formatted in the Format attribute value of the DATACONNECTOR operator definition of a Teradata PT job script