15.10 - RECORD - FastLoad

Teradata FastLoad Reference

prodname
FastLoad
vrm_release
15.10
category
Programming Reference
featnum
B035-2411-035K

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 ; 
    Completion Message

    The Teradata FastLoad completion message is:

    Starting record number set to :1000
    Ending record number set to   :20000

    Example  

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

    RECORD THRU 50000 ; 
    Completion Message

    The Teradata FastLoad completion message is:

    Starting record number set to :1
    Ending record number set to   :50000