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