Find downloads for extending the Teradata Database. Probably the most popular way of doing so is through the use of User Defined Functions, or UDFs, which are routines that operate on data stored in relational tables. We've provided a bunch of these that provide functionality such as emulating common functions available in lesser databases such as DB2 or Oracle, message digest functions for SHA-1 and MD5, and date/time calculations. Remember, you can easily develop your own UDFs, and if you have a UDF that you'd like to share with the world, please contact us, and you might find your name up in lights.

 

19 Downloads
download icon
1.0  -  12 Jun 2008

This UDF implements the great circle distance algorithm to determine the distance in miles between two points expressed in longitude and latitude. This distribution contains full source code, REPLACE FUNCTION SQL, a test suite and documentation.

download icon
1.0  -  02 Mar 2008

The self extractable file includes the lobload application to load UDF's, SP's etc. into Teradata as part of installation.

download icon
1.0  -  11 Sep 2007

Eight UDFs that search VARCHAR and CLOB string sources to see if they contain VARCHAR or CLOB string sets. Four of the UDFs are overloaded (named the same) to return the result in the form of VARCHAR or CLOB string while the other four UDFs are overloaded to return an INTEGER index into the string source if a match is found.

download icon
1.0  -  27 Jan 2005

Is_numeric() UDF checks a field to see if it converts to a Teradata numeric value. one use would be for the ETL process to use the UDF to check incoming data that's destined for DECIMAL and INTEGER columns.

download icon
1.0  -  27 Jan 2005

This package contains two string-related UDFs. The Edit Distance function returns the minimum number of edit operations required to transform string1 into string2. The N-Gram matching function returns the number of n-gram matches between two strings.

download icon
1.0  -  17 Jan 2005

SQL Scalar UDF that writes varbyte or varchar arg to MQ.

download icon
1.0  -  22 Jun 2004

In-place compression UDF. Compress column value for VARCHARs and BLOBS. Similar to zipping the column before inserting. Can also be used for encrypting data in the database. After compression data is unreadable until uncompressed.

download icon
1.0  -  22 Jun 2004

UDFs for Byte operations, such as bitwise AND, OR, XOR, NOT, SHIFT, and conversion of a byte value to character.

download icon
1.0  -  22 Jun 2004

Teradata UDFs for popular IBM DB2 functions.

Pages