RE: Sorting

1)  I don't use FMTDTA a whole lot.  But I've read the articles.  Yes, it 
can be faster, (at least at the time of the article), but you shouldn't 
notice it unless the file is quite sizable.

2)  CREATE VIEW shouldn't work for RGZPFM.  CREATE INDEX might.

3)  Whether or not creating an index is faster than just selecting the 
records you want may be based on a number of factors:
-  Is the volume of the data significant to where you'll notice
- If it's for a one shot deal, the overhead of creating the index, then 
accessing the data, might be just the same as just selecting the records. 
However, if it's for repeated access then create the index.
- There is some maintenance cost to maintaining an index.  It's the old 
speed of maintenance versus speed of reporting argument, and when you'll 
actually see the tradeoff.  Unlike CRTLF, CREATE INDEX does not have the 
parameter "MAINT" for Access Path Maintenance.



Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin