× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. September 2004

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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.