RE: Recovering deleted records

["Haas, Matt" <Matt.Haas@xxxxxxxxxxx>]

Or just download WRKDBF from http://www.wrkdf.com. It's free.

Matt

-----Original Message-----
From: Holden Tommy [mailto:Tommy.Holden@xxxxxxx]
Sent: Wednesday, September 22, 2004 5:00 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: Recovering deleted records


Have you tried creating the copy using CRTDUPOBJ?

Thanks,
Tommy Holden
HCA phone:  1-800-828-2561
direct line:  615-344-2151
fax: 1-866-593-0404



-----Original Message-----
From: SRamanujan@xxxxxxxxxxxxxxxxxx
[mailto:SRamanujan@xxxxxxxxxxxxxxxxxx]
Sent: Wednesday, September 22, 2004 3:51 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: Recovering deleted records


I have an emergency production issue and my client does not have wrkdbf.
I am trying the cpyf with compress(*no) but am getting no where.  MY
dspfd shows the same number of deleted records.  Then how do you compare
these 2 files?  The original was keyed and I created the copy with no
keys and did the cpyf. (I also tried to create a cpyf with record start
as 1) when I do a cmppfm, I get all records as mismatch.  

What am I doing wrong?

TIA,
Sudha

Sudha Ramanujan
SunGard Futures Systems
sramanujan@xxxxxxxxxxxxxxxxxx
(312) 577 6179
(312) 577 6101 - Fax
 
-----Original Message-----
From: Eric A. Wolf [mailto:eric_a_wolf@xxxxxxxxxxx] 
Sent: Monday, September 20, 2004 2:07 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Recovering deleted records

WRKDBF works great except in a situation that I ran into.  The software
product had a keyed PF so I could not look at the records.  I just
copied
the file into a new pf that had no key and it worked fine.  I ended up
using
the CPY ... COMPRESS(*NO)...

Eric

----- Original Message -----
From: <Terry@xxxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: Monday, September 20, 2004 10:33 AM
Subject: RE: Recovering deleted records


> I'm sure other's will mention this also, but check out WRKDBF.COM.
Bill
> Reger created this great utility and gives it away.  It includes a
> un-delete utility for mass undeletes, or you can un-delete specific
> records from within WRKDBF.
>
> Terry Richardson
> Vermont Information Processing, Inc.
> terry@xxxxxxxxxx
>
>
>
> "Ali Ekinci" <Ali.Ekinci@xxxxxxxxxx>
> Sent by: rpg400-l-bounces@xxxxxxxxxxxx
> 09/20/2004 01:26 PM
> Please respond to
> RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
>
>
> To
> "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
> cc
>
> Subject
> RE: Recovering deleted records
>
>
>
>
>
>
> I remember someone suggested
> Cpyf your file to some other library with "Compress out deleted
> records=*YES", then compare it with the original file. The additional
> records in the copied files are deleted records.
> Never tested, but sounds like it would work.
>
>  -----Original Message-----
> From:            Steve Morrison [mailto:smorrison@xxxxxxxxxxxxx]
> Sent:            Monday, September 20, 2004 1:14 PM
> To:              RPG programming on the AS400 / iSeries
> Subject:                 RE: Recovering deleted records
>
> John,
>
> I know ProData http://www.prodatacomputer.com/ has a utility to
recover
> deleted records, and Jim Sloan's TAATOOL package
http://www.taatool.com/
> includes a utility to recover deleted records. I haven't used either
one,
> so
> I can't comment on ease of use.
>
>
> Steve Morrison
> Beacon Insurance
> 940-720-4672
>
> -----Original Message-----
> From: John Furniss [mailto:JFurniss@xxxxxxxxxxxxxxxxx]
> Sent: Monday, September 20, 2004 10:49 AM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: Recovering deleted records
>
> List,
>                  We have a need to recover deleted records from a PF.
They
> are still
> "there" because we have not RGZPFMed the file and a WRKF tells me
there
> are
> deleted recs present. How can I undelete these? I saw a post in the
> archives
> where I can d/l a freeware utility from www.iseriesnetwork.com, but we
are
> not a member of that site.
>                  Thanks a million,
>
> John Furniss
> Allied Machine & Engineering Corp.
> iSeries Application Programmer
> Phone (330) 343-4283 Ext. 8371
> email: jfurniss@xxxxxxxxxxxxxxxxx
>
> --