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.

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.