Data Set Options for Relational Databases ERRLIMIT= Data Set Option 191
run;
The following example creates a new Teradata table, NEWDEPT, specifying the
Teradata data types for the DEPTNO and CITY columns.
data mydblib.newdept(dbtype=(deptno=’byteint’ city=’char(25)’));
set dept;
run;
The following example creates a new Teradata table, NEWEMPLOYEES, and
specifies a data type and attributes for the EMPNO column. The example encloses the
Teradata type and attribute information in double quotation marks. Single quotation
marks conflict with those that are required by the Teradata FORMAT attribute. If you
use single quotation marks, SAS returns syntax error messages.
data mydblib.newemployees(dbtype= (empno="SMALLINT FORMAT ’9(5)’
CHECK (empno >= 100 AND empno <= 2000)"));
set mydblib.employees;
run;
See Also
“DBFORCE= Data Set Option” on page 173
ERRLIMIT= Data Set Option
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)
DBMS support: DB2 OS/390, DB2 UNIX/PC, Informix, ODBC, OLE DB, Oracle, Microsoft
SQL Server, SYBASE, Teradata
Default value:
1
Syntax
ERRLIMIT=integer
Syntax Description
integer
is a positive integer that represents the number of errors after which SAS stops
processing and issues a rollback.
Details
SAS calls the DBMS to issue a rollback after a specified number of errors occurs during
the processing of inserts, deletes, updates, and appends. If ERRLIMIT= is set to 0, SAS
processes all rows, regardless of the number of errors that occur. The SAS log displays
the total number of rows processed and the number of failed rows, if applicable.
