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

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