OPNQRYF question

[boothm@xxxxxxxxxxxxxxxxx]

I need to select and sort a group of records from a 200,000 record file. 
OPNQRYF seems the right tool, but performance is horrid plus there's one 
step that I can't figure out.

The finished file has to be in order by substringing Column 3 through 27 
of FIELDB.  The Physical file is already keyed by FIELDB.   For sorting I 
tried KEYFIELD(*MAPFLD/FIELDBNBR) MAPFLD(FIELDBNBR '%SST(FIELDB 3 25)' ) 
but that wouldn't compile.

Any suggestions?
_______________________
Booth Martin
boothm@earth.goddard.edu
http://www.spy.net/~booth
_______________________

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