Passing Dynamic UDTs as an Alternative to Overloading Function Names - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™

Overloading a function provides applications with the ability to call one SQL UDF and pass arguments with data types that are determined at execution time.

Sometimes, however, defining C or C++ functions to handle many different combinations of parameter types can become cumbersome.

As an alternative to function overloading, consider defining a single C or C++ function with up to eight parameters that are defined as dynamic user-defined types (UDTs).

For details on using dynamic UDTs, see Defining Functions that Use UDT Types.