|
|
|
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.
|
|
|
|
|
|
|
UDF User’s Guide
This user’s guide describes the Teradata Warehouse 7.1 User Defined Function (UDF) feature. This guide is primarily targeted towards developers of UDFs and database administrators.
|
|
|
Two string UDFs (editdistance and N-Gram)
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.
|
|
|
|
|
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.
|
|
|
|
|
Oracle UDFs
A Collection of UDFs that emulate the most-commonly used Oracle built-in SQL functions.
|
|
|
|
|
UDFs for Byte Operations
UDFs for Byte operations, such as bitwise AND, OR, XOR, NOT, SHIFT, and conversion of a byte value to character.
|
|
|
Teradata UDF Packaging
The self extractable file includes the lobload application to load UDF's, SP's etc. into Teradata as part of installation. Please refer to the README file in this file for details.
|
|
|
UDF for Great Circle Distance Calculation
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.
|
|
|
UDFs for Month/Year Difference Determination
These UDFs implement difference determination in months/years using smaller units of granularity, days/months, to accurately calculate the difference. According to the ANSI SQL standard, units smaller than the unit of the result are to be ignored in an SQL calculation, but this can lead to results not consistent with business practices (Refer to NTA 1553). This distribution contains full source code, REPLACE FUNCTION SQL, a test suite and documentation.
|
|
|