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.