Re: File Reorg - Cons

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Another cheap native option is to use STRQMQRY - CRTQMQRY with the statement
  SELECT * FROM FILE
and then execute STRQMQRY OUTPUT(*OUTFILE) OUTFILE(same-file) OUTMBR(*FIRST 
*REPLACE)

USE WITH CAUTION

This replaces the original contents with the results of the SELECT 
statement, in place. I've not looked into the locking implications, but it 
probably still needs to run off-hours.

This is a powerful and frightening technique - any result set that matches 
the columns of the original table will replace the contents, in place, with 
no warning that it is doing so.

At 05:09 AM 4/28/2004, you wrote:
-snip-
> Or a cheap alternative would be to CPYF filename to copy COMPRESS(*YES)
> Compress out deleted records.
> CLRPFM the file, then CPYF copy to filename.
>
> Fiona Fitzgerald