Advanced Topics |
Default: | 1 |
Alias: | ERRLIMIT= |
See also: | DDBCOMIT= |
Syntax | |
Details |
Syntax |
DDBERLMT= n |
is a positive integer that represents the number of errors after which SAS stops processing and issues a rollback.
Details |
For insert, update, delete, and append operations, a rollback is issued when DDBERLMT= is reached. For read operations, processing stops when the specified number of errors occurs. If DDBERLMT is set to 0, no rollback is attempted and processing continues to completion regardless of the number of errors encountered.
For DDBERLMT= to be enforced, CA-Datacom/DB logging must be turned on and TXNUNDO=YES must be specified in the User Requirements Table (URT). TXNUNDO=YES is specified in the default URT that is shipped with SAS/ACCESS interface to CA-Datacom/DB software.
If you specify a value for DDBCOMIT= other than 0, rollbacks affected by the DDBERLMT= option might not include records that are processed unsuccessfully because they were already committed by DDBCOMIT=. The following table summarizes the interaction between DDBERLMT= and DDBCOMIT=.
DDBERLMT= | DDBCOMIT= | Result |
---|---|---|
1 | 0 | Defaults. No commit or rollback. Processing ends upon the first error. |
0 | 0 | No commit or rollback. Processing does not end upon an error. |
0 | >0 | A commit is performed when the transactions that are processed equal DDBCOMIT=. No rollback is performed. Processing does not end upon an error. |
>1 | 0 | No commit. A rollback is performed, processing ends. or both when DDBERLMT= is reached. |
>1 | >0 | A commit is performed when the commit count equals DDBCOMIT=. A rollback is performed when the error counts equals DDBERLMT=. If a multiple of DDBCOMIT= equals DDBERLMT=, then a rollback, not a commit, is performed when DDBERLMT= is reached. |
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.