Re: take 2: how to sort a file in place

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Actually using the DOCSQL command, this can be done in place - that 
command is part of an RJS product they have, right, Joel? It is 
basically the same as the various EXCSQL or RUNSQL commands that have 
used QMQRY techniques.

All he has to do is run the SELECT with a distinct and ba-da-boom -- 
oops, boom doesn't sound so good!! No, really, just direct output back 
to the file being queried and all is done.

In general, one could create a QMQRY object with a statement like SELECT 
DISTINCT FILE.* from LIB/FILE ORDER BY WHATEVER, then run STRQMQRY and 
set the OUTPUT and OUTFILE parameters as suggested. Using the product 
command is just an abstraction-level easier.

And there are no more <verndor response>'s!! No skin in the game anymore.

Vern

On 1/23/2013 1:28 PM, rob@xxxxxxxxx wrote:
> For that, you can't do it in place.  Use the work file.
>
>
> Rob Berendt