rs_delexception

Deletes a range of transactions identified by transaction ID in the exceptions log in the rs_exceptscmd, rs_exceptshdr, and rs_systext system tables.

Syntax

rs_delexception_id transaction_id_start [,transaction_id_end]

Parameters

transaction_id_start – ID number of the first transaction in the range that you want to delete.
transaction_id_end – ID number of the last transaction in the range that you want to delete. Specifying the last transaction in a range is optional.

Examples

Example 1 – Deletes from the exceptions log the transaction with ID number 1234. You can also use rs_delexception to delete a single transaction.
```
rs_delexception_id 1234
```
Example 2 – Deletes from the exceptions log all transactions with ID numbers between 1234 and 9800, inclusive.
```
rs_delexception_id 1234, 9800
```

Usage

rs_delexception_id deletes the range of transactions between transaction_id_start and transaction_id_end, inclusive of transaction_id_start and transaction_id_end from the exception tables.
If you do not specify any parameter, rs_delexception_id displays an error message. Use rs_helpexception or rs_delexception with no parameters to obtain a current list of valid transactions in the exceptions log.
If you specify a single valid value for a transaction ID in transaction_id_start, and do not specify a second transaction ID number in transaction_id_end, rs_delexception_id deletes only the transaction you specify in transaction_id_start.
If you enter 0 (zero) as a transaction ID number and do not enter a second transaction ID number, rs_delexception_id deletes all transactions in the exceptions log.
If you enter a floating point number, such as 123.456, and you are using:
- ERSSD – rs_delexception_id only processes the integer—123, and ignores the numerals after the decimal point
- RSSD – rs_delexception_id returns with an error message and you can reenter the command
rs_delexception_id displays an error message if the command you enter does not result in any transactions being deleted.