15.00 - Command Functions - FastLoad

Teradata FastLoad Reference

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

Command Functions

Table 21 describes the multifile Teradata FastLoad job scripts from the preceding example.

 

Table 21: 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

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

logoff;
and an endofjob status message, such as:
**** 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