The following table describes the multifile Teradata FastLoad job scripts from the preceding example.
|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.|