DDBERLMT= Data Set Option

Specifies the number of errors that are used before SAS stops processing and issues a rollback.

Alias:	ERRLIMIT=
Default:	1
See:	DDBCOMIT=

Syntax

Syntax Description

Details

Syntax

DDBERLMT= n

Syntax Description

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.

In order 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.