Assigning Structured UDTs - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
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™

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