15.00 - Completion Message - FastLoad

Teradata FastLoad Reference

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

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 ;