where the following is true:
-
tname
- Name of the table into which rows are inserted.
-
cname
- Name of column to receive a new row value during the insert operation.
- For each cname defined, a corresponding fieldname must be specified.
- A list of column names can be defined in any order. The column names do not have to be defined in the same order as they appear in the CREATE TABLE statement.
-
fieldname
- Field name that was defined in a previous DEFINE command.
- During the insert operation, Teradata FastLoad inserts the field in the input data record that was assigned to the fieldname into the corresponding column (cname) of the Teradata FastLoad table.
- .*
- Wildcard specification that all columns in tname that are used to construct the list of field names be used in the insert operation.
- When the wildcard specification is used, Teradata FastLoad queries the database for all of the column names and uses them to construct a valid INSERT statement.