Re: ITHL02 sort

[dslessman@xxxxxxxxxxxxxxxxxxxxxx]

Paul,

What are you using to "look" at the file.  ITHL02 is a logical view of the
physical file ITH.  If you are using Query/400 and do not specify the
fields to sort by, the data will be displayed in arrival sequence.

The file is actually correct but it will depend on how you access it.

Dwight Slessman



                                                                                
                                
                    Paul Holstein                                               
                                
                    <holstein13@exc        To:     BPCS-L@midrange.com          
                                
                    ite.com>               cc:                                  
                                
                    Sent by:               Subject:     ITHL02 sort             
                                
                    owner-bpcs-l@mi                                             
                                
                    drange.com                                                  
                                
                                                                                
                                
                                                                                
                                
                    08/01/2000                                                  
                                
                    04:02 PM                                                    
                                
                    Please respond                                              
                                
                    to BPCS-L                                                   
                                
                                                                                
                                
                                                                                
                                



ITHL02 is supposed to be sorted by TPROD, and TSEQ.  However, whenever I
look at the file, I notice it is not sorted at all.

I did a DSPFD on ITHL02 and it says it is sorted ascending by the two
fields.  Does anyone else have this problem?  How do I (or should I) fix
this?  Seams like this could make a big difference in performance.

--Paul Holstein
iWork Software, L.L.C.





_______________________________________________________
Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---




+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---