16.10 - SQL UDFs - Teradata Database

Teradata Database SQL Fundamentals

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
klx1480972732157.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

SQL UDFs allow you to encapsulate regular SQL expressions in functions and then use them like standard SQL functions.

Rather than coding commonly used SQL expressions repeatedly in queries, you can objectize the SQL expressions through SQL UDFs.

Moving complex SQL expressions from queries to SQL UDFs makes the queries more readable and can reduce the client/server network traffic.