16.20 - Teradata 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 external stored procedure development. For example, you can use the FNC_DbsInfo function to get session information related to the current execution of a procedure.

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

Category Use
ARRAY Data Type Interface Enable an external stored procedure to access and set the values of the elements in an ARRAY data type
Global Information Returns session information related to the current execution of an external stored procedure
Lob Access Enable an external stored procedure 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 an external stored procedure 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
Stored Procedure Invocation Provides a way to call a stored procedure from an external stored procedure
String Argument and Result Processing Useful for processing BYTE, CHAR, or VARCHAR parameters
TD_ANYTYPE Parameter Access Enable an external stored procedure to retrieve information about TD_ANYTYPE IN, INOUT, and OUT parameters
Trace Let you get trace output for debugging purposes during external stored procedure development
UDT Interface Enable an external stored procedure 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.