17.10 - Limiting Insertion Errors - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

Product
Parallel Transporter
Release Number
17.10
Release Date
June 2021
Content Type
Programming Reference
Publication ID
B035-2516-061K
Language
English (United States)

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.