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:

.*
Default VALUES clause for the insert operation
When the .* characters is used as a suffix with the tname specification, Teradata MultiLoad replaces these characters with a default VALUES clause before executing the command.
When using the .*default, tname must specify a table name and not a view name. The default option is most useful when used with the TABLE command, which builds the layout corresponding to the same table.
cname
Column of the specified table that is to receive the value from a field of matching input records
If cname specifications are not entered, Teradata MultiLoad uses the column identifiers as they were defined by the CREATE TABLE statement.
The value is identified by the corresponding entry in the fieldname list.
fieldname
Field of an input record, whose value is given to a column of the tname table that is identified by the corresponding cname specification of this command
Alternatively, each fieldname clause may instead be an expression that includes one or more actual fieldname terms.
tname
Table or view that is to receive rows from Teradata MultiLoad input data records
The tname specification must have been previously identified as tname1 in the BEGIN MLOAD command.
VALUES
The VALUES clause is of the form:
VALUES (:column1, :column2,...)
where: :column1,:column2,… are the names of the columns from tname in the order in which they were defined by the CREATE TABLE statement.