Command Functions Used in a Multifile FastLoad Job Script | Teradata FastLoad - 17.10 - Command Functions - 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)
Last Update
2021-07-01

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 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 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 database.