INSERT | Example 2 | Teradata FastLoad - 17.10 - Example 2: INSERT - 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)

The following command example establishes a list of field names from the definition of the Teradata FastLoad table:

DEFINE FILE=InFile;
INSERT OldTable.* ; 

The DEFINE command specifies the input data source (InFile) and defines each field to be inserted in the Teradata FastLoad table (OldTable).