At 09:15 AM 8/11/98, Lee Gunter wrote:
>SUPRTOOL (Robelle Consulting) and DBAudit (Bradmark Technologies) may be
>used to extract the desired records from the logs and put them into the
>database.
>
>Lee Gunter          [log in to unmask]
>
>
>
>
>From: [log in to unmask] on 08/11/98 08:05 AM
>
>Please respond to [log in to unmask]
>
>
>To:   [log in to unmask]
>cc:    (bcc: Lee Gunter/BCBSO/TBG)
>Subject:  Restoring purged dataset record
>
>
>
>
>Hi all,
>Does anyone know of a utility that will take database log file records
>(specifically DBDELETEs) and PUT them back into the database?
>TIA
>Dave Vorgang
>Medford School District
> 

No problem.

Recovering Deleted Records::
You can correct the improper deletion of entries (records) with DBAUDIT's
Extract command and DBGENERALs option 6.3 input mode.  First, create an MPE
file containing the data logged for the DBDELETEs in question.  Selecting the
correct entries to be 'extracted' is easy with the SELECT command.  

Example:

>input log001
>list calls del
>extract base1 set1 FILE1 {extract deletes only}
>list fields fields
>select program query.pub.sys {could select by user, etc.}
>purge FILE1 {default is to append}
>xeq
>exit


Now you have a file containing the entries which were deleted and DBGENERALs
option 6.3 can be used to input the file and load the dataset in question. 
SUPRTOOL can also be used to INPUT the flat file and BASE PUT to the dataset.

tj 




   Tim Joseph
   425-485-8536 (phone)
   [log in to unmask] (email)
   425-485-7801 (fax)
   http://www.bradmark.com/