DBLOAD Procedure

ERRLIMIT= Statement

Stops the loading of data after a specified number of errors
Default: 100 (see the DBMS-specific details for possible exceptions)

Syntax

ERRLIMIT=error-limit;

Details

The ERRLIMIT= statement stops the loading of data after the specified number of DBMS SQL errors has occurred. Errors include observations that fail to be inserted and commits that fail to execute. The ERRLIMIT= statement defaults to 10 when used with APPEND.
The error-limit argument must be a nonnegative integer. To allow an unlimited number of DBMS SQL errors to occur, specify ERRLIMIT=0. If the SQL CREATE TABLE statement that is generated by the procedure fails, the procedure terminates.