15.10 - Limiting Errors in the Stream Driver - Parallel Transporter

Teradata Parallel Transporter Application Programming Interface

prodname
Parallel Transporter
vrm_release
15.10
category
Programming Reference
featnum
B035-2516-035K

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

low

Many errors that are considered allowable

high

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.