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.
|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.