Using Clauses with UDTs or UDFs | CREATE/REPLACE FUNCTION | Teradata Vantage - 17.10 - RETURNS Clause - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

This mandatory clause specifies the data type of the parameter value returned by the function. You can specify any valid data type except TD_ANYTYPE, VARIANT_TYPE and TABLE, including UDTs.

The defined return data type is stored as an entry in DBC.TVFields using the name RETURN0[n], where n is a sequentially defined integer used to guarantee the uniqueness of the value. This ensures that user-defined parameter names are not duplicated.