Specifies the number of errors that are allowed while using the TPT FastLoad utility before SAS stops loading data to Teradata.
| Valid in: | DATA and PROC steps (wherever TPT or Fastload is used) |
|---|---|
| Category: | Data Set Control |
| Default: | none |
| Data source: | Teradata |
| See: | ERRLIMIT= data set option, DBCOMMIT= LIBNAME option, DBCOMMIT= data set option, ML_CHECKPOINT= data set option |
Table of Contents
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 TPT Fastload pauses. When TPT Fastload pauses, you cannot use the table that is being loaded. Restart capability for TPT Fastload is not yet supported, so you must manually delete the error tables before SAS can reload the table.
This option applies to TPT Load, Update, and Stream operations. For TPT, this option sets the value for TD_ERROR_LIMIT.
In this example, SAS stops processing and pauses TPT Fastload when it encounters the 10th 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;