System-Generated Constructor Functions and Observer/Mutator Methods | Vantage - 17.10 - System-Generated Constructor Functions - 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)

The system automatically generates a constructor function for each structured UDT you create. This constructor function returns a UDT value with all attributes initialized to an attribute value of NULL. This does not mean that a field value having the type is itself null. In fact, you can assign a null attributed structured UDT to a column specified with the NOT NULL column attribute.

Externally, the constructor function is a UDF whose name is the same as the structured UDF. You invoke the constructor method with no parameter, for example: udt_name().