Re: Alphabetizing detail records to a header file

A "Join" logical file will be an elgant solution, I belive performance
will be good, but I'm not sure.  A "View" created by sql also will work. 
_____________________________________________________________________
by way of David Gibbs wrote:
> 
> I have an idea I may have missed something obvious.
> 
> Here's the situation:  I have a Header File of names and addresses. The
> Header File has a unique identifying number for each name.  The numbers
> are assigned as each new name is added to the file so the numbers really
> amount to arrival sequence, not  to Alphabetic Sequence.   I do have a
> logical over the Header File based upon the name, so that any reports can
> be generated in alphabetic order.  All this seems simple and straight
> forward.
> 
> Now comes the part where I think I am missing something:  I also have an
> application with a small detail file for a  specialized application.  The
> small group is probably going to be about 300 records but certainly never
> over 1,000 records.  I've linked it logically with the Header File by the
> unique Header File I.D. number. To present an alphabetic subfile on the
> screen of that small grouping I have to read through the entire alpha
> logical on the Header File.  As you can imagine performance is horrid.
> 
> In the past I've loaded an *INZSR array, and I've denormalized the data.
> Neither method has felt right.  Is there some simple thing I've missed?
> 
> Thanks.
-- 
  Raul A. Jager W.
Asuncion - Paraguay
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---