RDR

Retrieve Deleted Records

Have you ever had that sinking feeling that occurs when the wrong records are deleted? If so, you realize how important RDR is for you. It is the cheapest insurance you can buy. Just don't wait until you have an emergency to get it! RDR retrieves those records you deleted in error.

  • Retrieve all deleted records from any member of a physical file
  • Retrieve deleted records from RRN to RRN
  • Include RRN in the output file for the deleted records

The input file is not changed in any way. The deleted records are put in a file of your choice, and then may be copied back into the original file. If all deleted records are not wanted, use the From and To Record to select the particular record(s).

The RDR command is easy to use. Just key in RDR and prompt. Fill in the parameters needed and <enter>. RDR will then create a file of the deleted records.

Without RDR, the retrieval of deleted records typically would require three manual steps. First, the user would have to restore the files in question. Next, one would have to search for the deleted records. Finally, records would have to be copied back to the file. Each step is time consuming and could be laden with errors. And, these steps only work if the file had been saved prior to the deletion of records. RDR takes the effort, delay and uncertainty out of retrieving deleted records from System i files.

RDR is so easy to use and offers the retrieval of ALL deleted records from a file or only records within a RRN (relative record number) range. Retrieved records will be placed in a second file, which can be designated on the RDR command. Relative record numbers can be attached to each record for further analysis. Building logicals over the retrieved deleted records can also help in locating the correct deleted records. (The physical RRN is shown on the display of the logical file records.) The desired records can then be copied back into the original file using CPYF or ProData's DBU database utility can reactivate the records one record at a time.

No matter what records need to be retrieved from deletion, RDR is the utility that allows you to handle it quickly and easily.

The RDR command is easy to use. Just key in RDR and prompt. Fill in the parameters needed and . RDR will then create a file of the deleted records.

RDR Quick Facts

Installation Time: Less than 5 minutes
Functions: Retrieve Deleted Records
Features: Retrieves all deleted records in a physical file or deleted records within RRN range, total number of retrieved records is displayed, can also retrieve individual records through ProData's DBU, database utility
Platforms: System i
System Requirements: OS/400 V4R2 or better

Products

FREE 30 Day Trial

Try RDR FREE for 30 days. Note: the RDR demo version will retrieve just one record to give you an example of how it is used. Once you purchase it and we provide the permanent access code, you will be able to retrieve multiple records from any specified file.

Case Studies

  • RDB Connect - Access Real-Time Driver Information
  • RDB Connect - Just What the Dr. Ordered
  • DBU, RDR & ProTools - Tedious Tasks Made Simple with ProData Utilities!
  • DBU - North Central Co-op Succeeds with AgVantage and DBU
  • DBUnifier - Create F4 Selection Lists in an Instant
  • RDR - RDR (Retrieve Deleted Records) Nothing Could Be Simpler
  • SQL / Pro - SQL / Pro Saves a City