RE: Deleted records

[Roger Boucher <RBoucher@xxxxxxxxxxx>]

I want to thank Al, Jim, and yourself for helping me to go farther down this
road than I ever wanted to <vbg>.  I got it working after digging out my
Cozzi book... haven't seen a program described file since school!!  We
already have UNDEL, but this file has 2 million records and 
I didn't want to scan 101 records at a time to find the deleted ones in
question.  Did anyone say journals?? <g>

Thanks again.

P.S.  If there is a way to change how many records to scan in UNDEL I'd be
pleased to hear about it.  Or if there is some way to display only undeleted
records maybe?  I couldn't find anything.

-----Original Message-----
From: dhandy@isgroup.net [mailto:dhandy@isgroup.net]
Sent: Friday, August 27, 1999 1:30 PM
To: MIDRANGE-L@midrange.com
Subject: Re: Deleted records


Roger,

>I compiled the RPG over this save file... what can I do to make the program
>happy?
>How do I change the program to open the file specifying a record length of
>528?

I just use a program-described file with a record length of 528, and
input specs to name the 528 bytes as a DS (in RPG III) or a field (in
RPG IV).  There is no real benefit to using an externally-described
definition for a SAVF since you don't get subfields anyway.

>Again, am I completely going down the wrong track?

For un-deleting records, I'd say Yes.  Dave McKenzie released a
freeware utility which uses MI to retrieve the data without the need
to copy to a SAVF.   It will display and optionally undelete records
directly from the file, so is fast even with large files.  And it
works at security levels 40 or 50.

You can get the source and compiled versions for RISC or CISC at the
News/400 website, under shareware/freeware.  Goto
http://www.news400.com/shareware/rtvList.dbm then search for UNDEL.
Download the version(s) you need for your hardware.

I've never (yet) had to use this program, but I like having this kind
of stuff in my toolbox *before* I need it.  It seems to work as
advertised in the little I played with it.

Doug
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---