Syntax - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
aim1544831946660.ditamap
dita:ditavalPath
gyk1507317446489.ditaval
dita:id
B035-2409
lifecycle
previous
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.