Re: Recovering deleted records

You might want to try WRKDBFUNDL that comes with WRKDBF


joeM


----- Original Message -----
From: <SRamanujan@xxxxxxxxxxxxxxxxxx>
To: <rpg400-l@xxxxxxxxxxxx>
Sent: Wednesday, September 22, 2004 4:32 PM
Subject: RE: Recovering deleted records


> Thanks everyone.
> I ftped the file to where wrkdbf is installed and am trying to undelete
> now. I have around 20000 records and I am not able to get past 9999
> (subfile?) I haven't hit the deleted records yet.  How can I get to the
> records past 10000?  Can I automatically undelete without going through
> each of them?
>
> Sudha Ramanujan
> SunGard Futures Systems
> sramanujan@xxxxxxxxxxxxxxxxxx
> (312) 577 6179
> (312) 577 6101 - Fax
>
>
> -----Original Message-----
> From: Bob Cozzi [mailto:cozzi@xxxxxxxxx]
> Sent: Wednesday, September 22, 2004 4:14 PM
> To: 'RPG programming on the AS400 / iSeries'
> Subject: RE: Recovering deleted records
>
> Do they have DBU? It allows you to undelete records.
> If they don't have WRKDBF, then download and install it, it is free!
> Also if they have the file attributes set to Reuse Deleted Records *YES,
> then your screwed anyway.
> -Bob Cozzi
>
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of 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
> >
> > --
> > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> list
> > To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
> unsubscribe,
> > or
> > change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives at
> > http://archive.midrange.com/rpg400-l.
> >
> > --
> > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> >
> >
> >
> >
> > --
> > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> >
> >
> > --
> > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> >
> >
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>