Register | Login


Frequently Asked Questions

What is a UDF?

What version of a driver works with a specific release of the Teradata database?

What version of the client operating system is certified to support a specific driver?
Are previous versions of drivers certified to work with new releases of the Teradata database - for example TTU 7.0 drivers working with V2R5.1?
What will I be able to download from this site and how do I install a driver that has been downloaded from this site?
Where can I get documentation for the Teradata connectivity drivers.
Which version of the JDBC Specification is Teradata's JDBC Type 4 Driver Compliant with?
What is a UDF?

A Teradata Database UDF is a program that operates on data stored in relational tables. UDFs allow users to add their own extensions to the Teradata SQL language. A UDF is referred to as a routine in the SQL-99 standard. In the SQL-99 standard a routine can be a function, method, or a procedure. In addition routines can be classified as internal, written in SQL, or external written in another language such as C, C++ or JAVA. The Teradata Warehouse 7.1 UDF feature provides the C language external routine "function" as defined by the SQL-99 standard. When a UDF is created it becomes part of the Teradata SQL language and is accessible to everyone who has the appropriate access rights. A UDF can operate on any supported Teradata Database data type and return a value of any supported Teradata Database data type, which allows UDFs to participate in SQL expressions and be utilized, for the most part, wherever Teradata's built-in functions are used.

Top
What version of a driver works with a specific release of the Teradata database?

Teradata certifies a driver with the current version of the Teradata database and up to two prior releases of Teradata. For example, a driver from the TTU 7.1 product set is certified and supported with V2R5.1, V2R5.0, and V2R4.1.x. On the download "results" page, each driver listed also indicates the versions of the Teradata database that it is compatible with.

Top
What version of the client operating system is certified to support a specific driver?

In general, we attempt to certify the current release of an operating system - IBM AIX, for example - and the prior releases. For example, for IBM AIX, we have certified our TTU 7.1 ODBC and JDBC drivers on IBM AIX 5.2 and AIX 5.2. View the Supportability Chart for easy reference.

Top
Are previous versions of drivers certified to work with new releases of the Teradata database - for example TTU 7.0 drivers working with V2R5.1?

No, we do not certify or support this configuration.

Top
What will I be able to download from this site and how do I install a driver that has been downloaded from this site?

In general the files that are downloaded are single files containing the required files to install the driver. For Windows, both WIN32 and WIN64 are contained in a single self extracting installation package. The UNIX platforms SPARC, AIX, HPUX, and MPRAS are all packaged up into a single TAR file. For Linux, there is a single RPM. For JDBC in the TTU 8.0 release, the JDBC driver will be delivered as a single jar file named "terajdbc4.jar," which is a single zero-install jar file, not an executable. Prior to downloading, each download provides installation instructions on the download page.

Top
Where can I get documentation for the Teradata connectivity drivers.

http://www.info.teradata.com/datawarehouse/eTeradata-BrowseBy.cfm?page=Teradata%20Tools%20and%20Utilities

Top
Which version of the JDBC Specification is Teradata's JDBC Type 4 Driver Compliant with?

We list our JDBC 2.0 compliance in the customer documentation (www.info.teradata.com):

Teradata Driver for the JDBC Interface User Guide Acrobat PDF B035-2403-093A Teradata Tools and Utilities 7.1.0, Release 03.01.00 Dec 08, 2003

In Appendix B, JDBC Methods, Supported Methods, which actually lists all the methods and whether they are supported or not.

Top
Company Newsroom Site Help Site Map Privacy/Legal Contact Us