Show TOC

rs_delexception_idLocate this document in the navigation structure

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

rs_delexception_id <transaction_id_start> [,<transaction_id_end>]

ID number of the first transaction in the range that you want to delete.


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

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
  • 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:
    rs_delexception_id only processes the integer—123, and ignores the numerals after the decimal point
    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.