Example 1: INSERT - FastLoad

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.