Re: Qryout file problem

[John Cirocco <JCirocco@xxxxxxxxxx>]

How about a simple RPG pgm?

Assuming Part Number is you key on first file,  ReadE on part and build array, 
when ReadE hits end of key, write Part# and Location Array.  Loop to next part#.

John

>>> John Taylor <John.Taylor@britax-pmg.com> 04/27 6:13 AM >>>
If anyone can find a way to resolve this problem it would make my week.

I need to generate a file containing part numbers and locations with one
record per part number with multiple locations, from a file containing
multiple records per part number.

eg from this Part Number Location
  1234  A001A
  1234  A003C
  1234  C010D
  4567  A009B
  4321  B001A
  4321  B012D

to this  1234  A001A A003C C010D
  4567  A009B
  4321  B001A B012D

I believe I can do this using multiple queries utilising result fields and
summaries but as of now I have not fathomed it out.


Thanks

John 
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                        
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---