Example 1: INSERT - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2019-02-14
dita:mapPath
ybx1527114222321.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following command example defines the EmpRecs input data source and the fields in each record (Emp_Number and Emp_Name):

DEFINE Emp_Number (INTEGER), Emp_Name (VARCHAR(30)),
   FILE=EmpRecs ;
INSERT INTO Employee (EmpNo, Name) VALUES
   (:Emp_Number, :Emp_Name) ; 

The INSERT statement defines the table and columns to receive new data values.

For each data record, the value in the first field (Emp_Number) is inserted in the EmpNum column and the value in the second field (Emp_Name) is inserted in the Name column.