Command Functions - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2019-02-14
dita:mapPath
ybx1527114222321.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following table describes the multifile Teradata FastLoad job scripts from the preceding example.

Teradata FastLoad Terminating Commands  
Command Description
BEGIN LOADING Specifies the name of the Teradata FastLoad table and the two error tables, and starts the loading phase of the Teradata FastLoad job

After executing the BEGIN LOADING command in the Teradata FastLoad job script that initiates the job and loads the first data source, the Teradata FastLoad response signifies the start of a new job:

BEGIN LOADING COMPLETE

In subsequent multifile Teradata FastLoad job scripts, the Teradata FastLoad response is:

FastLoad is continuing

   a multifile job.

CREATE TABLE Creates a new Teradata FastLoad table, ensuring it is empty when the Teradata FastLoad job initiates
DEFINE Identifies the field in each record to be inserted into the Teradata FastLoad table and specifies the name of the input data source

The field names should be the same for all of the multifile Teradata FastLoad job scripts.

The FILE= attribute, however, successively identifies a different source data source for each portion of the multifile Teradata FastLoad job.

DROP TABLE Makes sure that the Teradata FastLoad table and the two error tables do not already exist on the Teradata Database when the Teradata FastLoad job initiates
END LOADING Distributes all of the rows to the Teradata FastLoad table

The following message indicates that the command executed successfully:

END LOADING COMPLETE
At this point, the Teradata FastLoad table and the two error tables are unlocked and available to any user with the appropriate privileges.
INSERT Transfers the data records from the specified input data source to the Teradata FastLoad table

The Teradata Database automatically takes a checkpoint after the last record of each insert operation.

LOGOFF Pauses the Teradata FastLoad operation when executed before an END LOADING command, which is the case for each multifile Teradata FastLoad job script that identifies a new data source

Because the LOGOFF command is entered during the loading phase, Teradata FastLoad responds with the following message:

FastLoad Paused.

When a Teradata FastLoad job is paused during the loading phase, the tables remain locked and cannot be accessed until Teradata FastLoad executes the END LOADING command.

When submitted after an END LOADING command, as in the last multifile Teradata FastLoad job script, the LOGOFF command terminates the Teradata FastLoad job. In this case, Teradata FastLoad displays the following:

logoff;

and an end-of-job status message, such as the following:

**** 16:11:42 Logging off all sessions
**** 16:11:45 Total processor time used = '0.358802 Seconds'
     .        Start : Fri Jan 10 16:11:20 2014
     .        End   : Fri Jan 10 16:11:45 2014
     .        Highest return code encountered = '0'.
**** 16:11:45 FDL4818 FastLoad Terminated

and then presents the system command prompt.

LOGON Logs user JWT on to the Teradata Database