16.20 - FNC_GetStructuredAttribute - 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 an attribute of a structured type that is defined to be an input parameter to a UDF, UDM, or external stored procedure.

The attribute must be one of the following types:
  • Non-LOB predefined type, such as INTEGER or VARCHAR
  • Distinct UDT
  • Structured UDT
  • JSON

To get the value of a LOB attribute of a structured type, use the C library routine FNC_GetStructuredInputLobAttributeByNdx.

For best performance, use FNC_SetStructuredAttributeByNdx instead of this routine. This routine is supported for ease of use.