tdr.GetFormat Function | R Table Operators | Teradata Vantage - 17.10 - tdr.GetFormat - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
Returns an integer that indicates the record format attribute for the given stream as follows:
  • 1 for IndicData with row separator sentinels
  • 2 for IndicData with no row or partition separator sentinels


tdr.GetFormat(  attribute,  streamno,  direction  )

Syntax Elements

Parameter type: character

The format attribute to be retrieved.

Currently, the only valid value for attribute is "RECFMT", which defines the input/output record format.

Parameter type: integer

The stream number.

Parameter type: character
Valid values are as follows:
  • "R" (input)
  • "W" (output)

Usage Notes

This function can be called from the table operator as well as the contract function.

Example: Print the Record Format of an Input Stream

The following statement prints the record format of input stream 0:

print(tdr.GetFormat("RECFMT", 0, "R"))