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