Teradata provides application classes that you can use for Java external stored procedure development. For example, you can use the DbsInfo class to get session information related to the current execution of a procedure.
The following table shows some of the categories of classes that Teradata provides.
Category | Use |
---|---|
Lob Access | For an external stored procedure that uses an SQL BLOB or CLOB type parameter and specifies a data access clause of NO SQL in the CREATE PROCEDURE or REPLACE PROCEDURE statement |
Global Information | Returns session information related to the current execution of an external stored procedure |
Query Band | Provides methods for external stored procedures that need to access query band information for a session, transaction, and/or profile |
Trace | Let you get trace output for debugging purposes during external stored procedure development |
For a list of all available classes and their descriptions, see Java Application Classes.