Information for the Database Administrator |
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.
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.