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.