Restart Teradata FastLoad Job & Load Second Data Source | Teradata FastLoad - 17.10 - Restart the Teradata FastLoad Job and Loading the Second Data Source - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.10
Published
June 2021
Last Update
2021-07-01
Content Type
Programming Reference
Publication ID
B035-2411-061K
Language
English (United States)

The following Teradata FastLoad job script loads the Teradata FastLoad table shown in the previous example with data from the data source named SecondFile:

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