16.20 - Purpose - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
April 2020
Content Type
Programming Reference
Publication ID
English (United States)

Returns the value of a non-LOB attribute of a structured UDT.

The attribute must be one of the following types:

  • Non-LOB predefined type, such as INTEGER or VARCHAR
  • Distinct UDT
  • Structured UDT

To get the value of a LOB attribute of a structured type, use one of the following:

  • FNC_GetStructuredInputLobAttributeByNdx
  • FNC_GetStructuredResultLobAttributeByNdx