Re: Reading keyed file sequentially

Boy, is my face red. That has to be it. Thanks.
 And FWIW, all the records are read but it matters what order they are read
in. They must be read in keyed by company and date.


 On 11/3/05, Wilt, Charles <CWilt@xxxxxxxxxxxx> wrote:
>
> In your RPG program, does the f-spec have the 'K' for keyed file?
>
> Without the 'K', RPG reads in arrival sequence.
>
> HTH,
>
>
> Charles Wilt
> --
> iSeries Systems Administrator / Developer
> Mitsubishi Electric Automotive America
> ph: 513-573-4343
> fax: 513-398-1121
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of James Newman, CDP
> Sent: Thursday, November 03, 2005 12:58 PM
> To: MIDRANGE-L@xxxxxxxxxxxx
> Subject: Reading keyed file sequentially
>
> FWIW, I'm at V5R2. I have a "transaction-type" file that is keyed on
> company
> (10A) and date(D). Each day records are added for lots of companies.
> When
> browsing the PF, I was not surprised to see records not in the order
> specified by the key but in arrival order. However, I wrote a program to
> read this file sequentially and it read it that way too - not in keyed
> order.
> I know I could reorg the file before running the program to put the
> records
> in the order specified by the key. I also know I could create an LF and
> have
> the program read it. Because the file is really big (+20 million
> records) I
> did neither since I thought the reorg would run too long and the
> overhead of
> maintaining an LF would be too great. Thoughts? TIA.
> Jim Newman
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>