15.10 - Limiting Errors in the Stream Driver - Parallel Transporter

Teradata Parallel Transporter Application Programming Interface

Parallel Transporter
Programming Reference

Limiting Errors in the Stream Driver

Use the ErrorLimit attribute to limit the number of errors captured in the error table during the Stream job.


Table 26: Stream Driver ERRORLIMIT Values 

IF you expect your Stream job to encounter...

THEN specify an ERRORLIMIT value that is...

No errors or very few errors


Many errors that are considered allowable


Note: The ErrorLimit specification applies to each instance of the Stream application, not to all instances combined. If, for example, you set the limit to 10,000, then a single instance would have to detect that 10,000 rows were inserted into the first error table in order to terminate the job, and those 10,000 rows would have to be controlled by the sessions managed by that instance.

Processing terminates when the number of errors encountered reaches the error limit. If, for example, you expect no errors in the input data, set the error limit value to one. In this case, the job terminates when any record causes an error.