Teradata Application Classes | Java External Stored Procedures | Vantage - Teradata Application Classes - Analytics Database - Teradata Vantage

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-07-11
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1147
lifecycle
latest
Product Category
Teradata Vantageā„¢

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.