RE: HELP... I accidentally deleted too many records!!

["Wills, Mike N. (TC)" <MNWills@xxxxxxxxxxxxxx>]

I did get everything back okay, thanks guys for the help! 

-----Original Message-----
From: Al Barsa [mailto:barsa@xxxxxxxxxxxxxxxxxxx]
Sent: Thursday, May 22, 2003 1:58 PM
To: Midrange Systems Technical Discussion
Subject: Re: HELP... I accidentally deleted too many records!!







Restore the file to another library, and use CPYF to selectively copy back
what you lost.  This is not a good solution if relative record numbers are
meaningful, but if the file contains some sort of date/time stamp, you
might be able to re-organize them back properly.

Journaling is a good thing.  Had you used "before and after images",  you
could have simply used RMVJRNCHG.

Al

Al Barsa, Jr.
Barsa Consulting Group, LLC

400>390

914-251-1234
914-251-9406 fax

http://www.barsaconsulting.com
http://www.taatool.com


midrange-l-bounces@xxxxxxxxxxxx wrote on 05/22/2003 11:41:42 AM:

> Okay, this wouldn't be so bad if our back worked last night, but it
didn't.
>
> I did an SQL delete to purge out some records, it purged too many. Can
> anyone tell me a way to restore all of them? There is no journal on the
> file.
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.