The
interface view engine does not perform recovery processing as part of its normal behavior. The
engine issues a
database commit statement only once after a procedure or DATA step completes, unless an error
is encountered. When an error is encountered, processing stops and no rollback is
attempted. You can implement basic recovery techniques by using the DDBCOMIT= and
DDBERLMT=
data set options, either individually or together. The DDBCOMIT= option enables you to specify
the number of records that are processed before a database commit is issued, including
rows that are not processed successfully. DDBERLMT= enables you to specify the number
of errors before SAS stops processing and initiates a rollback. For more information
about the options, including their interaction with each other, see
Data Set Options.