17.00 - Limiting Insertion Errors - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

prodname
Parallel Transporter
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2516-220K

Use the TD_ERROR_LIMIT attribute to limit the number of insertion errors captured in ErrorTable1 during the acquisition phase of a Load job.

TD_ERRORLIMIT Values 
Load Driver Job Quality ERRORLIMIT Value
No errors or very few errors low
Many errors that are considered allowable high

The ErrorLimit specification applies to each instance of the Load driver, not to all instances combined. For example, you set the limit to 10,000 rows. A single instance must detect that 10,000 rows were inserted into the first error table to terminate the job, and those 10,000 rows must be controlled by the sessions managed by that instance.