Re: How to view data in alphabetical order in a subfile

Yes, keeping the subfile in an array could be smart, but if the DB you are 
reading from, is big(a customer file is often BIG), and you just need a 
handfull of those records, I would still posistion in the DB and reload the 
subfile...

Mvh.

Geir Kildal

.


-----Original Message-----
From: cobol400-l-bounces@xxxxxxxxxxxx
[mailto:cobol400-l-bounces@xxxxxxxxxxxx]On Behalf Of Jon Paris
Sent: Friday, April 07, 2006 2:50 PM
To: 'COBOL Programming on the iSeries/AS400'
Subject: Re: [COBOL400-L] How to view data in alphabetical order in a
subfile


Rather than re-load the subfile from the DB I would tend to keep the subfile
record "images" in an array.  Then when the user requests sorting by a
specific column, all you have to do is sort the array and reload the
subfile.  Simplicity itself and more efficient than hitting the DB again. 


Jon Paris
Partner400

www.Partner400.com
www.RPGWorld.com