FNC_TblOpGetBaseInfo Function | C Library Functions | Teradata Vantage - FNC_TblOpGetBaseInfo - Analytics Database - Teradata Vantage

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-03-30
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
qnu1472247494689
lifecycle
latest
Product Category
Teradata Vantageā„¢

Get the information on the base type or attribute types for a UDT or complex data type (CDT).

Syntax

void
FNC_TblOpGetBaseInfo(FNC_TblOpColumnDef_t *colDefs,
                     UDT_BaseInfo_t       *baseInfo)

Syntax Elements

colDefs
A pointer to a structure containing information about the column definitions of a stream passed or returned from a table operator. The size of this structure depends on the number of attributes in the table. This is an input parameter.
baseinfo
A pointer to an array of structures, with each entry containing the metadata needed to describe a UDT or CDT column. The size of this structure depends on the number of columns in the table. If the column is a structured UDT, either with or without attributes that are structured UDT, metadata about the attributes may be retrieved by a subsequent call to FNC_TblOpGetStructuredAttributeInfo.
This is an output parameter.

Usage Notes

This routine is only supported with table operators and enables a UDT or complex type to be passed as an input column or returned as an output column.

This routine supports the following UDTs and CDTs:
  • ARRAY/VARRAY
  • DATASET
  • Distinct and structured UDTs
  • Geospatial types: ST_Geometry, MBR, MBB
  • JSON
  • Period types
  • XML
The base_* fields of the UDT_BaseInfo_t structure are not filled for structured UDTs. Because structured UDTs may have multiple attributes and contain an arbitrary level of nesting, metadata about the attributes of a structured UDT is retrieved using FNC_TblOpGetStructuredAttributeInfo. The FNC_TblOpGetStructuredAttributeInfo routine returns an array of attribute_info_t structures corresponding to all of the attributes in the structured UDT.

For more information about the FNC_TblOpColumnDef_t and UDT_BaseInfo_t structures, see Table Operator Data Structures.