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.