Syntax: UPDATE|Stand Alone utility - Syntax - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
Product Category
Teradata Tools and Utilities


where the following is true:

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
  • Values from fields of input data records
tname
Table or view to be updated
This table was previously identified as tname1 in the BEGIN MLOAD command.
If tname is not explicitly qualified by database name, the current default database qualifies it.
WHERE condition
Conditional clause that specifies 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.