Specifies the number of errors that are used before SAS stops
processing and issues a rollback.
| Default: |
1
|
| Alias: |
ERRLIMIT=
|
| See also: |
DDBCOMIT=
|
- n
-
is a positive integer that represents the number of errors
after which SAS stops processing and issues a rollback.
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=.
Interaction between the DDBERLMT= and DDBCOMIT= Data Set Options
|
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.
