Retrieve Deleted Records

Dan

unread,

Oct 17, 2001, 9:22:45 PM10/17/01

to

I have a file that has approx. 3000 records and 100 deleted records. I was
told to copy the file with compress delteted records (*NO) and the new file
would have all the records but this didn't work for some reason. Does anyone
know how I can retrieve those deleted records?

Thanks,
Daniel

Francis Lapeyre

unread,

Oct 17, 2001, 10:01:13 PM10/17/01

to

There is a freeware utility that I have on our machine that will undelete records, if you know what the RRN's of the deleted records are. It's called UNDEL. I'm not able to get onto my work network now, and I'm going on vacation Friday, maybe someone else has the source.

--

Regards,
Francis Lapeyre

"Facilius est camelum per foramen acus transire quam divitem intrare in regnum Dei."
(Mk 10:25)

Return address is filtered via SpamCop.

"Dan" <D...@nospam.com> wrote in message news:F9qz7.20194$zG.16...@news1.rdc1.ga.home.com...

elb...@cmfurniture.com

unread,

Oct 18, 2001, 9:04:32 AM10/18/01

to

www.prodatacomputer.com

They have some good commercial database utility products. I could no
longer work on a AS400 without their DBU product.

They have a Retreive Deleted Records utility program (RDR).

I once downloaded it and used its one time free trial to restore some
deleted records in a file.

Bob Luebbe

unread,

Oct 18, 2001, 12:53:30 PM10/18/01

to

Check out Surveyor/400 at www.linomasoftware.com

It has a graphical undelete feature.

"Dan" <D...@nospam.com> wrote in message
news:F9qz7.20194$zG.16...@news1.rdc1.ga.home.com...

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 80,000 Newsgroups - 16 Different Servers! =-----

Francis Lapeyre

unread,

Oct 18, 2001, 10:38:26 PM10/18/01

to

Found a link to UNDEL:

http://www.dukeserver.de/news400/abo/down/tools/soa1.zip

--

Regards,
Francis Lapeyre

"Facilius est camelum per foramen acus transire quam divitem intrare in regnum Dei."
(Mk 10:25)

Return address is filtered via SpamCop.

"Francis Lapeyre" <flap...@spamcop.net> wrote in message news:XCqz7.5538$K8.4...@e3500-atl1.usenetserver.com...

Walter

unread,

Oct 19, 2001, 3:04:55 AM10/19/01

to

If you copied the file into another one without the deleted records they are
not included in the target file.

You can get back deleted records in afile with many tools. No one is
included in OS/400. I use Bradley Stone's freeware (www.wrkdbf.com).
Installed in a minute and one of the best programs that IBM never wrote.

Walter

Dave McKenzie

unread,

Oct 19, 2001, 10:49:41 AM10/19/01

to

Just to set the record straight, WRKDBF was written by Bill Reger.
However, Bradley's SPLTOOL is also one of the best programs that IBM never
wrote :-)

--Dave

Van

unread,

Oct 27, 2001, 3:46:39 AM10/27/01

to

"Francis Lapeyre" <flap...@spamcop.net> wrote in message news:<llMz7.6963$B3.2...@e3500-atl2.usenetserver.com>...

hi!
Your deleted records you can retrieve by means of R-STUDIO. I used
this utilities for restoring of my accidentally deleted records and
all files were restored. Look site http://www.r-tt.com for more
information
Good luck!