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.
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. |
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 ;
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 ;
The Teradata FastLoad completion message is:
Starting record number set to :1
Ending record number set to :50000