16.20 - Assigning Structured UDTs - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

For purposes of structured UDTs, assignment operations are defined to be insert, update, and parameter passing SQL operations only.

A structured UDT value can only be assigned by default with a source of the same type. To support assigning a different data type to a structured UDT target, you must create a cast that can be invoked implicitly on assignments from the desired type to the structured UDT (see CREATE CAST and REPLACE CAST).