Re: Having the same file open twice in an RPG program

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Still running that v3r2 system?

Then yeah, a new logical is needed (or you could use SQL)

Assuming a modern system
dcl-f FOO2 extdesc('FOO') extfile(*extdesc) rename(FOOR:FOOR2);

extdesc controls where the RPGIV compiler gets the definition for the file
extfile controls what file is actually opened.

EXTFILE is nice, you can use it instead of needed an OVRDBF...

Charles



On Wed, Apr 22, 2020 at 12:10 PM James H. H. Lampert <
jamesl@xxxxxxxxxxxxxxxxx> wrote:

> I have a situation, with a header file, FOO, and a line-item file, BAR,
> in which I need to have both files open twice in the same program. It
> seems that there are some 92000 cases in which the same header appears
> twice, and (presumably) each has an identical set of line-item records.
>
> As it happens, I can (and indeed, *must*) have two different logicals
> open on FOO, in order to be positioned to both of the mutually redundant
> headers.
>
> But for each of those pairs, I also need to run through the line items,
> in order to compare the line items of one to the line items of the other.
>
> I can't recall ever being able to have the same file open twice in an
> RPG program, other than by having two different LFs on the same PF.
>
> Is there something I'm not aware of?
>
> --
> JHHL
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com