INSERT | Example 2 | Teradata FastLoad - Example 2: INSERT - FastLoad

Teradata® FastLoad Reference - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
FastLoad
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-17
dita:mapPath
dlf1641281592734.ditamap
dita:ditavalPath
vax1619194969834.ditaval
dita:id
wzs1478610185776
Product Category
Teradata Tools and Utilities

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).