INSERT SQL Statement| Syntax | Teradata FastLoad - 17.10 - Syntax - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.10
Published
June 2021
Last Update
2021-07-01
Content Type
Programming Reference
Publication ID
B035-2411-061K
Language
English (United States)

INSERT SQL statement syntax diagram

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.