Initiate Teradata FastLoad Job & Load First Data Source | Teradata FastLoad - 17.20 - Initiate the Teradata FastLoad Job and Loading the First Data Source - FastLoad

The following Teradata FastLoad job script begins the multifile Teradata FastLoad job and loads data from the data source named FirstFile into the Teradata FastLoad table:

LOGON tdpid/jwt,smart ;
DROP TABLE Fast_Table ;
DROP TABLE Error_1 ;
DROP TABLE Error_2 ;
CREATE TABLE Fast_Table (col1 (char(5),
   col2(integer)) ;
BEGIN LOADING Fast_Table ERRORFILES Error_1, Error_2 ;
DEFINE Field_1 (char(5)), Field_2 (integer)
   FILE = FirstFile ;
INSERT INTO Fast_Table (col1, col2) VALUES
   (:Field_1, :Field_2) ;
LOGOFF ;