Re: Alphabetizing detail records to a header file

[boothm@xxxxxxxxxxxxxxxxx]

Did I miss something here?  When I  "Select the Alpha Name from the secondary 
file (Header) as the key" I  got 
a halt saying the key must be from the first file on the left.  If I move 
the huge file to the left side I am expecting huge performance problems 
although I admit I haven't tried it yet.  Any ideas what I missed?
_______________________
Booth Martin
boothm@earth.goddard.edu
http://www.spy.net/~booth
_______________________




Bob Larkin <blarkin@wt.net>
Sent by: owner-rpg400-l@midrange.com
12/09/1999 12:46 AM
Please respond to RPG400-L

 
        To:     RPG400-L@midrange.com
        cc: 
        Subject:        Re: Alphabetizing detail records to a header file

If I understand the question, create a logical or view withthe DETAIL file 
as the
primary file joining to the Header file. The join would be on the "arrival
sequence Unique ID number field". Select the Alpha Name from the secondary 
file
(Header) as the key. The max reads would be the total number of records in 
the
detail file. It sounds like you have used the JDFTVAL keyword in your 
join, in
which case  the join is backwards, resulting in a view with the total 
number of
records equal to the number of records in the Header file (unless you use 
an
Inner Join which would result from no JDFTVAL keyword.)

The logical below should work. Let us know if it does the trick.

|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
      A          R JOINREC                   JFILE(DETAIL HEADER)
      A          J                           JOIN(DETAIL HEADER
      A                                      JFLD(DetailUniqueID 
HeaderUniqueID)
      A            UniqueID         JREF(DetailUniqueID)
      A            NAME
      A           ..... fields .......
      A         K NAME



+---
| 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
+---