ERRLIMIT= LIBNAME Option

Specifies the number of errors that are allowed while using the Fastload utility before SAS stops loading data to Teradata.
Valid in: DATA and PROC steps (wherever Fastload is used)
Default: 1 million
Data source: Teradata
See: ERRLIMIT= data set option, DBCOMMIT= LIBNAME option, DBCOMMIT= data set option, ML_CHECKPOINT= data set option

Syntax

ERRLIMIT=integer

Syntax Description

integer
specifies a positive integer that represents the number of errors after which SAS stops loading data.

Details

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 yet supported, so you must manually delete the error tables before SAS can reload the table.

Example

In this example, SAS stops processing and pauses Fastload when it encounters the tenth error.
libname mydblib teradata user=terauser pw=XXXXXX ERRLIMIT=10;
data mydblib.trfload(bulkload=yes dbtype=(i='int check (i > 11)') );
     do
         i=1 to 50000;output;
     end;
run;