Show TOC

rs_delexception_dateLocate this document in the navigation structure

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

Syntax
rs_delexception_date <transaction_date_start> [,<transaction_date_end>]
Parameters
transaction_date_start

The originating date of the earliest transactions in the range that you want to delete. Enclose the date in double quotation marks.

transaction_date_end

The originating date of the latest transactions in the range that you want to delete. Specifying the latest transaction originating date in a range of dates is optional. Enclose the date in double quotation marks.

Examples
Example 1

Deletes from the exceptions log the transactions with an originating date of 1st October 2010.

rs_delexception_date "10/01/2010"
Example 2

Deletes from the exceptions log all transactions that have originating dates between 1st October 2010 and 31st October 2010, inclusive.

rs_delexception_date "10/01/2010", "10/31/2010"
Usage
  • You can enter the dates for <transaction_date_end> and <transaction_date_end> in the different formats supported by the Adaptive Server hosting the RSSD or the SQL Anywhere database that is the ERSSD. For information about acceptable date and time formats, see:
    • Adaptive Server Enterprise Reference Manual: Building Blocks > System and User-Defined Datatypes > Date and time datatypes > Entering date and time data
    • SQL Anywhere Server - SQL Reference > SQL Data Types > Date and Time Data Types > Sending Dates and Times to the Database.
  • rs_delexception_date deletes the range of transactions between <transaction_date_start> and <transaction_date_end>, inclusive of <transaction_date_start> and <transaction_date_end> from the exception tables.

  • If you do not specify any parameter, rs_delexception_date displays an error message. See the "org date"column when you execute rs_helpexception or rs_delexception with no parameters to obtain a current of valid transactions and originating dates in the exceptions log.

  • If you specify a valid date only for <transaction_date_start>, and do not specify a second valid date in <transaction_date_end>, rs_delexception_date deletes only the transactions you specify in <transaction_date_start>.

  • rs_delexception_date displays an error message if the command you enter does not result in any transactions being deleted.
Related Information