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

Teradata FastLoad Reference

Product
FastLoad
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.