Teradata Application Classes | Java External Stored Procedures | Vantage - 17.10 - Teradata Application Classes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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.