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 ;
These examples do not use a RECORD command to specify a range of records in the input data sources. By default, they load the entire contents of each source into the Teradata FastLoad table. To specify a range of records, use a RECORD command before each INSERT statement in multifile Teradata FastLoad job scripts.