File Name: book_UDF_A02_v_1.doc File Size: 456 kb Release Date: 6/6/2004 4:53:28 PM This 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. Reference [1] serves as a companion guide for developing UDFs and reference [2] serves as a reference for UDF Data Definition Language syntax. This document focuses on UDF: Architecture, Creation, Registration, Debugging techniques, Administration and Recommended Practices. It is recommended that [1] and [2] be read before reading this document. Information that is covered in detail in [1] and [2] is not covered in this document. Information covered in detail in [1] and [2] includes: Parameter Styles, Null handling, SQL to/from C data type conversions and rules (string truncation), Function Name Overloading, UDF Interface APIs and UDF Return values.
|
|
|
|