UPDATE (Upsert Form) | Teradata Vantage - 17.00 - UPDATE (Upsert Form) - Teradata Database

Teradata Vantageā„¢ - Time Series Tables and Operations

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-1208-170K

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.