The LIBNAME Statement for Relational Databases

ERRLIMIT= LIBNAME Option

Specifies the number of errors that are allowed while using the Fastload utility before SAS stops loading data to Teradata.

Default value:	1 million
Valid in:	DATA and PROC steps (wherever Fastload is used)
DBMS support:	Teradata

Syntax
Syntax Description
Details
Example

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 the following 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;

Top of Page