Re: OPNQRYF question

[fkolmann@xxxxxxxxxxxxx]

I don't know if it will work, but perhaps set up a DDS lgl such as below
and try to get the OPNQRYF to recognise the new existing LGL
so that its performance will improve rather than building its own lgl
every time.
*************** Beginning of data ********************************
     A          R RCDFMT                   PFILE(FILE)
     A            DAT1           6
     A            DAT2           5
     A            FIELDB      75
     A            FLDB2                I      SST(FIELDB 3  25)
     A          K FLDB2

Frank Kolmann

boothm@earth.Goddard.edu wrote:

> 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?
>
+---
| 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
+---