Extensibility covers the mechanisms by which you, as the user or developer, can extend the functionality of the Teradata Database, for example with the use of User Defined Functions, or UDFs.

Expand All Subscribe to Teradata Developer Exchange - Extensibility content The Latest
UDF Packaging for Teradata 12.0

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

Sample UDFs for String Searching

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.

Is_numeric() UDF

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.

Edit Distance and N-Gram string UDFs

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.

WebSphere MQ Client UDF

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

Byte Operation UDFs

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

Teradata UDFs for popular IBM DB2 functions

Teradata UDFs for popular IBM DB2 functions.

In-place compression UDF

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.

UDF User Guide

This user guide describes the Teradata Warehouse 7.1 User Defined Function (UDF) feature. This guide is primarily targeted towards developers of UDFs and database administrators. For the most part SQL language users of UDFs are unaware of the difference between UDFs and System Defined Functions and so a limited amount of discussion is required on using UDFs in the SQL language.

Download the user guide here.

Pages