Using a Dynamic UDT - Advanced SQL Engine - Teradata Database

Follow these steps to use a dynamic UDT as the data type of an input parameter to an external UDF:

1. In the CREATE FUNCTION or REPLACE FUNCTION statement for the UDF, specify the data type of up to eight input parameters as VARIANT_TYPE.
2. Write, test, and debug the C or C++ source code for the UDF.
3. Call the UDF, using the NEW VARIANT_TYPE expression to construct instances of dynamic UDT arguments and define up to 128 attributes for each UDT.