The LIBNAME Statement for Relational Databases |
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
|
-
integer
-
specifies a positive integer that represents
the number of errors after which SAS stops loading data.
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.
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;
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.