15.00 - Completion Message - FastLoad

Teradata FastLoad Reference

prodname
FastLoad
vrm_release
15.00
category
Programming Reference
featnum
B035-2411-034K

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.

 

Table 32: RECORD Completion Message Conditions 

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.

 

Table 33: Usage Notes for ERRLIMIT

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 ;