System-Generated Constructor Functions and Observer/Mutator Methods | Vantage - System-Generated Constructor Functions - Teradata Vantage - Analytics Database

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-12-13
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jbg1472252759029
lifecycle
latest
Product Category
Teradata Vantage™

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().