The following table describes the things to consider when using the RECORD command.
|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:
If an invalid record number is specified, Teradata FastLoad returns an error message:
|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.