16.20 - Teradata UDF Library Functions - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

Teradata provides functions that you can use for UDF development. For example, use the FNC_DbsInfo function to get session information related to the current execution of a UDF.

The following table shows some of the categories of library functions that Teradata provides.

Category Use
Aggregate Intermediate Storage Allocates the intermediate storage you need for accumulating summary information in an aggregate function
ARRAY Data Type Interface Enable a UDF to access and set the values of the elements in an ARRAY data type
Global Information Returns session information about the current execution of a UDF
Lob Access Enable a UDF to use a locator to access the contents of a referenced object and to append data to a LOB object
Period Data Type Interface Enable a UDF to access and set the value of a Period data type
Query Band Access Return query band name-value pairs that have been set on a session, transaction, or profile to identify the originating source of queries and help manage task priorities and track system use
String Argument and Result Processing Useful for UDFs that are used for the algorithmic compression and decompression of table columns
Table Function Processing Required to implement table functions
TD_ANYTYPE Parameter Access Enable a UDF to retrieve information about TD_ANYTYPE input and output parameters
Trace Let you get trace output for debugging purposes during UDF development
UDT Interface Enable a UDF to access and set the value of a distinct UDT or attribute values of a structured UDT

For a list of all available functions and their descriptions, see C Library Functions.