× 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.


  • Subject: RE: Fastest way to delete records.
  • From: Rich Duzenbury <rduz@xxxxxxxxxxxxxxxxxxx>
  • Date: Thu, 08 Feb 2001 13:35:58 -0600

The application users won't know the difference - so perhaps the 
reorganization can take place at a more appropriate time (like 2am).  It 
depends on how 'available' the file has to be.  Perhaps the file should be 
set to REUSEDLT(*YES) as well, which can minimize the need to reorganize.

Regards,
Rich

At 01:13 PM 2/8/01 -0600, you wrote:
>Also ... the big time consumer is still there .. REORGING THE FILES .. to
>recover the DASD..! .. This process is dependent on the number of Logical
>files as well as the size of the original physical file! .. This is still my
>favored archiving solution.
>
>-----Original Message-----
>From: Rich Duzenbury [mailto:rduz@westernmidrange.com]
>Sent: Thursday, February 08, 2001 1:23 PM
>To: RPG400-L@midrange.com
>Subject: Re: Fastest way to delete records.
>
>
>Whoops, I forgot to add: Delete the 'K' on Terry.Rhoades example file specs
>so the files will process in arrival sequence!
>
>Regards,
>Rich
>
>
> >>H
> >>FORIGFILE  UP   E           K DISK
> >>FBKUPFILE  O    E           K DISK
> >>C                   IF        TIMESTAMP <=  YYYYMMDD
> >>C                   WRITE     BKUPFILE
> >>C                   DELETE    ORIGFILE
> >>C                   ENDIF
> >>
> >>
> >>It's not pretty, and it's not the fastest.   But if you compile it and
> >>run it in batch, it will be done before everyone is finished
> >>discussing it.  <G>
>
>+---
>| This is the RPG/400 Mailing List!
>| To submit a new message, send your mail to RPG400-L@midrange.com.
>| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator:
>david@midrange.com
>+---
>+---
>| This is the RPG/400 Mailing List!
>| To submit a new message, send your mail to RPG400-L@midrange.com.
>| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: david@midrange.com
>+---

Regards,
Rich

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.