UDTs and UPDATE (Upsert Form) - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

UDTs and UPDATE (Upsert Form)

UDT expressions can be used in an upsert form of UPDATE statement in any way that is consistent with the general support of UDTs by INSERT and UPDATE and with existing semantics for UPSERT (see “Inserting Into Distinct UDT Columns” on page 354, “Inserting Into Structured UDT Columns” on page 355, “Updating Distinct UDT Columns” on page 479, and “Updating Structured UDT Columns” on page 479.

The UPDATE statement used in the upsert operation can also use a mutator SET clause if it updates a structured UDT column (see “Updating Structured UDTs Using a Mutator SET Clause” on page 481).