16.20 - Using a Dynamic UDT - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageâ„¢ SQL Fundamentals

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
zce1519094756513.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
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.