Completion Message - FastLoad

Completion Message

The completion message indicates that the Teradata FastLoad job was either paused or terminated, depending on whether the job was in the loading phase or not:

If the job is in the loading phase, then Teradata FastLoad responds:

*** 16:09:18 Logging off all sessions

*** 16:09:21 Total processor time used = '0.374402 Seconds'

    .        Start : Fri Jan 10 16:08:59 2014

    .        End   : Fri Jan 10 16:09:21 2014

    .        Highest return code encountered = '4'.

*** 16:09:21 FastLoad Paused

If the job is not in the loading phase, then Teradata FastLoad responds:

**** 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

RECORD

Purpose  

The RECORD command defines the records of the input data source at which Teradata FastLoad processing starts and ends.

Syntax  

where:

Syntax Element	Description
startrecordnumber	Record at which processing begins. The default is record 1.
THRU	Keyword that introduces the optional endrecordnumber parameter.
endrecordnumber	Record after which processing ends. The endrecordnumber number must be equal to or greater than startrecordnumber.

Usage Notes

Table 47 describes the things to consider when using the RECORD command.

Table 47: Usage Notes for RECORD 

Topic	Usage Notes
Entering the RECORD Command	Enter the RECORD command before the INSERT statement in the Teradata FastLoad job. If a RECORD command is not used, Teradata FastLoad reads from the first record in the data source to the last record, unless the job is restarted.
Restarting Teradata FastLoad Jobs	When a job restarts, if the CHECKPOINT option is enabled, the utility begins reading at the next record immediately after the last checkpointed record.
Invalid Record Numbers	The RECORD command cannot specify invalid record numbers, such as: An endrecordnumber less than a startrecordnumber A negative value If an invalid record number is specified, Teradata FastLoad returns an error message: If the error occurs before the BEGIN LOADING command, then all Teradata FastLoad sessions are logged off and the utility is exited. If the error occurs after BEGIN LOADING, then the job pauses (all Teradata FastLoad sessions are logged off and the tables named in BEGIN LOADING remain locked until END LOADING is executed).
THRU Specification	If the THRU endrecordnumber parameter is not specified, Teradata FastLoad begins to read at startrecordnumber and continues until it finds the last record in the data source.

Example  

The following command example specifies the records in the input data source starting at record 1,000 and stopping at record 20,000:

RECORD 1000 THRU 20000 ;