RE: Reclaiming Delete Record Space....

["Graap, Ken" <keg@xxxxxxxxxxxxxxx>]

        >> >Is RGZPFM the only way you can remove delete records from a
physical
        >> >data file or can it be accomplished via some save restore
process too?
        >>
        >> Well, you could always do a CRTDUPOBJ DATA(*NO) to create an
empty
        >> file with the same structure, then do a CPYF to copy the
records to
        >> the new file.  After the copy is done, delete the original
file and
        >> move the new file into it's place.

        >Save file to tape, delete and restore.  Deleted records won't
be restored to
        >file.

        James - I've heard others say this is true, but I have not been
able to find any reference in an IBM manual confirming this.

        Wouldn't doing this also create the potential for messing up a
process that accesses data via relative record number?


Kenneth

--
********************************
        Kenneth E. Graap
  AS/400 Systems Administrator
    NW Natural - Information Services
             System Services
          503 226 4211 X5537
           FAX  503 721 2521
        keg@nwnatural.com
********************************


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