Usage Notes - FastLoad

Teradata FastLoad Reference

Product
FastLoad
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-18
dita:mapPath
tjz1488824663315.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following table describes the things to consider when using the RECORD command.

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.