Stops the loading of data after a specified number of errors
| Default: | 100 (see the DBMS-specific details for possible exceptions) |
|---|---|
| Requirement: | The error-limit argument must be a nonnegative integer. |
| Interaction: | The ERRLIMIT statement defaults to 10 when used with APPEND. |
| Tip: | To allow an unlimited number of DBMS SQL errors to occur, specify ERRLIMIT=0. |
specifies the number of DBMS SQL errors that are allowed before SAS/ACCESS stops loading data.
Errors include observations that fail to be inserted and commits that fail to execute. If the SQL CREATE TABLE statement that the procedure generates fails, the procedure ends.