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

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
ije1544831946874.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities


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.