rs_delexception_id

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

Examples

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