RE: Sorting

Uh, I don't think a view will work for the KEYFILE part.... That parm refers
to the access path to for the reordering of the PF data.  A view by itself
has no access path, and I don't think SQL allows you to use derived fields
as indexes..... :(

The bit about needing to substring the sort fields.... Is this a
non-described file (flat)? 

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Metz, Zak [mailto:Zak_Metz@xxxxxx]
Sent: Wednesday, April 30, 2003 2:49 PM
To: Midrange Systems Technical Discussion
Subject: RE: Sorting


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.


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.