Teradata Libraries - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
poj1484765174891.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
Product Category
Teradata Tools and Utilities

The Teradata Libraries give you access to Java stored procedure utilities (javFnc) and query band functionality using the Teradata Access Session Manager. The Teradata Plug-in for Eclipse Wizards utilize the Teradata Libraries, and all JAR files are available from any Teradata Project that you create.

The javFnc.jar contains the DBS java classes used to handle JARs, JDBC helper functions, and parameter helper functions. This JAR is used with the Teradata Java User Defined Function and Java Stored Procedure Multi-Page Editors. For information about the javFnc JAR file, see SQL External Routine Programming.

The Teradata Access Session Manager handles the Teradata Access Session class and query band configuration by managing the controls and wraps for a Teradata Database transaction. The query band is set at the beginning of a transaction and later released at the end of the transaction using the Teradata Access Session Manager user interface.

The Teradata Access Session Manager has both the iBatis and JDBC implementations that are supported by Teradata Plug-in for Eclipse. These implementations are available in the tdcommons-access JAR file. Query band information is available in the ThreadLocalContext class which is available in the tdcommons-context JAR file.