Scalar and aggregate UDFs are powerful tools for creating extensions to Teradata Database SQL when built-in functions cannot satisfy all of your needs. UDFs can be written to leverage Teradata Database's ability to store mass quantities of data and allow you to take full advantage of new, nonstandard data type support. Businesses can write UDFs to maximize the return on their Teradata investment by allowing them to better utilize the data that are already stored in their data warehouse.

Create UDFs to add power and flexibility to your database applications. Table functions open up vast new horizons. As part of the SELECT statement, they can take data from internal and external sources, process it, and even insert it back into Teradata Database. Secure Server Logic is new in Teradata Database V2R6.1. In order to allow UDFs and external procedures to do operating system I/O safely and to provide them with the correct allowed OS server user context, an authorization statement has been added.