RE: Sorting

["Metz, Zak" <Zak_Metz@xxxxxx>]

Agreed on RUNSQLSTM being extra work. The files in question belong to
customers running our software, so I'm afraid there's really no way I
will have any clue ahead of time how they will be sorted. I think I'm
stuck on Eric's idea of dynamically building a CREATE VIEW statement
without building the AP, then RGZPFM referencing that view. And as an
added bonus, I don't end up with a second file. Thank you!

> -----Original Message-----
> From: Chevalier, Rick
> 
> I would probably use embedded SQL.  You could also update a 
> source member
> and then use the RUNSQLSTM command to execute it.  That seems 
> like extra
> work to me though.
> 
> Is there any way to determine if particular fields are used 
> in the sort more
> frequently than others?  Anything that could be done in the 
> way of indexing
> will help.  
>
NOTICE: This E-mail may contain confidential information. If you are not
the addressee or the intended recipient please do not read this E-mail
and please immediately delete this e-mail message and any attachments
from your workstation or network mail system. If you are the addressee
or the intended recipient and you save or print a copy of this E-mail,
please place it in an appropriate file, depending on whether
confidential information is contained in the message.