RE: Sorting and filtering subfiles

["Jonathan Mason" <jonathan.mason@xxxxxxxxxxxxxxxx>]

<snip>
  I write out the subfile to a work file in qtemp, which has 
  the same fields with one extra "KEY" field.  I load the 
  sorted columns data into both the matching field and the 
  "KEY" field, then reload the subfile from the indexed work 
  file in QTEMP.    
</snip>

I like the idea, but doesn't this mean that you're reading the 
data twice before writing the record to the subfile?  Presumably
the extra key field is a character field long enough to hold the
largest field on the subfile.

For example:

a) Read record from database file
b) Write record to QTEMP file
c) Repeat until end of file...

d) Read record from QTEMP file
e) Write record to subfile
f) Repeat until page full or end of file...

Best regards

Jonathan