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