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

Teradata Vantageā„¢ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)

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.