ERRLIMIT=

ERRLIMIT=

Stops the loading of data after a specified number of errors.

Optional statement

Default: 100; see your DBMS chapter for possible exceptions.

Syntax
Details

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 an observation that failed to be inserted or a commit that failed to execute.

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.

An editing statement, such as ERRLIMIT=, must be specified after the database connection statements when you create and load a DBMS table. See LOAD for more information.

Chapter Contents
Previous
Next
Top of Page

	Optional statement
Default:	100; see your DBMS chapter for possible exceptions.