Completion Message
The Teradata FastLoad completion message for the END LOADING command depends on whether the job includes a RECORD command.
Table 32 describes the possible RECORD command Completion messages.
Job |
Teradata FastLoad Response Layout |
If the Job includes a RECORD command |
Total Records Read = 500
‑ skipped by RECORD command = 50
‑ sent to the RDBMS = 450
Total Error Table 1 = 25
Total Error Table 2 = 0
Total Inserts Applied = 425
Total Duplicate Rows = 0
|
If the Job does not include a RECORD command |
Total Records Read = 500
Total Error Table 1 = 25
Total Error Table 2 = 0
Total Inserts Applied = 475
Total Duplicate Rows = 0
|
ERRLIMIT
Purpose
The ERRLIMIT command limits the number of records that can be rejected while inserting data into the Teradata FastLoad table.
Syntax
where:
Syntax Element |
Description |
n |
Maximum number of records that can be rejected before executing the END LOADING command. The default error limit value is 1000000. |
Usage Notes
Table 33 describes the things to consider when using the ERRLIMIT command.
Topic |
Usage Notes |
Limiting Insertion Errors |
Use the ERRLIMIT command to limit the number of insertion errors captured in the first error table (errortname1) during the loading phase of a job. Processing terminates when the number of errors encountered reaches the error limit. If, for example, errors are not expected in the input data, set the error limit value to one. In this case, the job terminates when any record causes an error. Note, however, that when the specified error limit is reached, Teradata FastLoad continues processing until each session completes its current data block. This continued processing can cause the total number of error rows captured in the first error table to exceed the ERRLIMIT specification. |
Restarting a Job |
A job can be restarted from the last checkpoint if it terminates because the error limit is reached. If checkpoints were not taken, restart the job from the beginning. |
Example
The following command example terminates the job after 20 errors:
ERRLIMIT 20 ;