Specifies the number of errors that are allowed before SAS stops processing and issues a rollback.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Default: | 1 |
| Data source: | Amazon Redshift, Aster, DB2 under UNIX and PC Hosts, DB2 under z/OS, Google BigQuery, Greenplum, HAWQ, Impala, Informix, Microsoft SQL Server, Netezza, ODBC, OLE DB, Oracle, PostgreSQL, SAP ASE, SAP HANA, SAP IQ, Snowflake, Teradata, Vertica, Yellowbrick |
| Notes: | Support for HAWQ was added in SAS 9.4M3. |
| Support for Amazon Redshift was added in the April 2016 release of SAS/ACCESS. | |
| Support for Google BigQuery and Snowflake was added in the August 2019 release of SAS/ACCESS. | |
| Support for Yellowbrick was added in SAS 9.4M7. | |
| See: | DBCOMMIT= LIBNAME option, DBCOMMIT= data set option, ERRLIMIT= LIBNAME option, ML_CHECKPOINT= data set option |
Table of Contents
specifies a positive integer that represents the number of errors after which SAS stops processing and issues a rollback.
SAS ends the step abnormally and calls the DBMS to issue a rollback after a specified number of errors while processing inserts, deletes, updates, and appends. If ERRLIMIT=0, SAS processes all rows no matter how many errors occur. The SAS log displays the total number of rows that SAS processed and the number of failed rows, if applicable.
If the step ends abnormally, any rows that SAS successfully processed after the last commit are rolled back and are therefore lost. Unless DBCOMMIT= 1, it is very likely that rows can be lost. The default value is 1000.
This option applies to TPT Load, Update, and Stream operations. For TPT, this option sets the value for TD_ERROR_LIMIT.
A rollback to the last checkpoint does not take place on reaching the specified number of errors because the rows without errors have already been sent to Teradata.
SAS stops loading data when it reaches the specified number of errors and FastLoad pauses. When FastLoad pauses, you cannot use the table that is being loaded. Restart capability for FastLoad is not supported, so you must manually delete the error tables before SAS can reload the table.
In this example, SAS stops processing and issues a rollback to the DBMS at the occurrence of the 10th error. The MYDBLIB libref was assigned in a prior LIBNAME statement.
data mydblib.employee3 (errlimit=10);
set mydblib.employees;
where salary > 40000;
run;