Pages
|
Starting from TD 13.10, Teradata DIPUDT script creates the SQLRestrictedWords_TBF function and the SQLRestrictedWords view in the SYSLIB database that allow users and client products to query for Teradata SQL Restricted words.
,
07 Jun 2010
|
|
Hello all, Thanks.
,
31 Mar 2010
| 5 comments
|
|
How will you be able to use the new user defined functions with persistent memory feature to speed up your operations? We will examine three use cases and performance information regarding User Defined Functions with Persistent Memory. Specifically a persistent regular expression UDF is presented and the use of Role based persistent information is discussed. An overview is of the feature, its administration, and the basic architecture is also covered.
,
08 Feb 2010
|
|
This book provides reference information about BTEQ (Basic Teradata Query), a general-purpose, command-based report and load utility tool. BTEQ provides the ability to submit SQL queries to a Teradata Database in interactive and batch user modes, then produce formatted results.
,
02 Feb 2010
| 1 comment
|
|
Map-reduce, or its open source version Hadoop, is a parallel programming framework for running scripts, Java, C, and other external programming languages on hundreds of nodes. It is popular with Dot.Com companies who have large server farms and need to produce reports on website activity or produce search indexes. In general, Map-reduce applications overlap BI applications and data warehouses. However, Map-reduce applications can coexist with a data warehouse: one parallel processing, the other parallel database. Coexistence allows each subsystem’s best capabilities to be used to complement the other. With Teradata’s in-database processing technology, Map-reduce can become MPP ETL subsystem, or we can run Map-Reduce functions inside the EDW, or using table functions we can directly integrate with the Map-reduce nodes. This article illustrates a commonly used Map-reduce function running inside the Teradata EDW.
,
19 Oct 2009
| 1 comment
|
|
|
From time to time I’m asked how one might go about writing an UDF or an INMod or some other procedural extension to the database. The question isn’t a “where do I learn C or C++” question; rather it is a how do I go about debugging and testing my extension without the overheads and constraints of running within the database (or utility).
,
01 Aug 2009
| 20 comments
|
|
|
A collection of UDFs that emulate the most-commonly used Oracle built-in SQL functions.
,
22 Jun 2008
| 15 comments
|
|
|
These UDFs implement difference determination in months/years using smaller units of granularity, days/months, to accurately calculate the difference.
,
15 Jun 2008
|
|
|
This UDF implements the Secure Hash Algorithm, SHA-1, for computing a condensed representation of a message. When a message of any length < 264 bits is input, the SHA-1 produces a 160-bit output called a message digest (FIPS 180-1 / RFC 3174). This distribution contains full source code, a test suite, scripts, and documentation.
,
12 Jun 2008
|
|
|
This UDF implements the MD5 message-digest algorithm. The algorithm takes as input a message of arbitrary length and produces as output a 128-bit "fingerprint" or "message digest" of the input (RFC1321). This distribution contains full source code, a test suite, scripts, and documentation.
,
12 Jun 2008
| 6 comments
|
|
|
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.
,
12 Jun 2008
|
|
|
The self extractable file includes the lobload application to load UDF's, SP's etc. into Teradata as part of installation.
,
02 Mar 2008
|
|
|
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.
,
11 Sep 2007
|
|
|
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.
,
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.
,
27 Jan 2005
|
|
|
|
|
|
Teradata UDFs for popular IBM DB2 functions.
,
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.
,
22 Jun 2004
|
|
|
UDFs for Byte operations, such as bitwise AND, OR, XOR, NOT, SHIFT, and conversion of a byte value to character.
,
22 Jun 2004
|
|
|
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.
,
31 Jul 2003
| 2 comments
|