The DBLOAD Procedure for Relational Databases |
Stops the loading of
data after a specified number of errors
Default: |
100 (see the DBMS-specific details for possible
exceptions)
|
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.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.