INSERT | Example 1 | Teradata FastLoad - Example 1: INSERT - 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

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.