15.00 - Assigning Structured UDTs - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

Assigning Structured UDTs

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/ REPLACE CAST” on page 212).