User-defined function (UDF) - Call-Level Interface Version 2

Teradata Call-Level Interface Version 2 Reference for Workstation-Attached Systems

Product
Call-Level Interface Version 2
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
ggf1488824663364.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

By providing a mechanism that supports the creation of SQL functions, scalar and aggregate UDFs allow users to add their own extensions to Teradata Database SQL. These functions can be used to operate on any Teradata Database data type and can be utilized wherever built-in functions are used. If a function doesn’t exist to perform a specific task or algorithm, write one that does. UDFs can also simplify complex SQL syntax.