Isolated Loading Options
- WITH ISOLATED LOADING
- The UPDATE can be performed as a concurrent load isolated operation.
- NO
- The UPDATE is not performed as a concurrent load isolated operation.
- CONCURRENT
- Optional keyword that can be included for readability.
Target Table Options
- table_name_1
- Name of the table or queue table in which the row set is to be updated, or the name of the view through which the base table is accessed. The table must have a primary index and can be row-partitioned but cannot be column partitioned.
SET Clause
- column_name = expression
- Value expression to be updated in column column_name. This can be a DEFAULT function.
- mutator_method_name
- name of a mutator method that is to perform some update operation on column_name.
WHERE Clause
- condition
- The predicate that specifies the row to be updated:
- If the UPDATE target is a SET table with a UPI, then only one row can be updated per request.
- If the UPDATE target is a SET table with a NUPI or a MULTISET table, then multiple rows can be updated per request.
- table_name_2
- Name of the table or queue table in which the row set is to be inserted, or the name of the view through which the base table is accessed.
VALUES Clause
- expression
- The non-default set of values to be inserted into table_name_2.
- DEFAULT
- DEFAULT (column_name)
- The DEFAULT function should update the column with its default value in the position by which it is called in the expression list.
- column_name
- Column set into which the values specified by expression are to be inserted.
- DEFAULT VALUES
- A row consisting of default values is to be added to table_name.
ANSI Compliance
The upsert form of UPDATE is a Teradata extension to the ANSI SQL:2011 standard.