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