UPDATE (Upsert Form) | Teradata Vantage - 17.10 - UPDATE (Upsert Form) - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Time Series Tables and Operations

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1208-171K
Language
English (United States)

You cannot perform an isolated load on a PTI table.

You cannot specify the DEFAULT VALUES option to update a PTI table.

For complete information about UPDATE (Upsert Form), see Teradata Vantageā„¢ - SQL Data Manipulation Language, B035-1146.

UPDATE (Upsert) Rules and Restrictions

You cannot specify the system generated TD_TIMEBUCKET column in the UPDATE (Upsert Form) statement.

You cannot update the system generated columns TD_TIMEBUCKET, TD_TIMEBUCKET, or TD_SEQNO in an UPDATE (Upsert Form) statement. Also, you cannot update any of the columns defined in the COLUMNS specification of the PRIMARY TIME INDEX.

The WHERE clause must include equality predicate on the following columns to match a single row for updating:
  • TD_TIMECODE column
  • TD_SEQNO column, for sequenced PTI tables
  • All of the columns defined in the COLUMNS specification of the PRIMARY TIME INDEX.

If a match cannot be found, an insert operation is performed.