15.00 - Initiate the Teradata FastLoad Job and Loading the First Data Source - FastLoad

Teradata FastLoad Reference

prodname
FastLoad
vrm_release
15.00
category
Programming Reference
featnum
B035-2411-034K

Initiate the Teradata FastLoad Job and Loading the First Data Source

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 ;

Note: 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.