Syntax - Parallel Data Pump

Teradata® Parallel Data Pump Reference

Product
Parallel Data Pump
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
oqw1608578437373.ditamap
dita:ditavalPath
ovd1619195504008.ditaval
dita:id
B035-3021
lifecycle
previous
Product Category
Teradata Tools and Utilities


where the following is true:

tname
Table or view to be updated
This table was previously identified as tname in the BEGIN LOAD command. If tname is not explicitly qualified by database name, the current default database qualifies it.
cname
Column whose value is to be replaced by the value of expr
The column named must not be a column of the primary index.
expr
Expression whose resulting value is to replace the current value of the identified column
The expression can contain any combination of constants, current values of columns of the referenced row, or values from fields of input data records.
References to fields of input data records are as follows:
:fieldname
where :fieldname is defined by a FIELD command or TABLE command of the layout referenced by an IMPORT using this UPDATE.
WHERE condition
Conditional clause specifying the row or rows to be updated
The conditional clause can use values from fields of input data records by referring to their field names as follows:
:fieldname
where fieldname is defined by a FIELD command or TABLE command. Equality values for all the columns of the primary index must be explicitly specified in this clause.