RE: OVRDBF from an RPG?

-----Message d'origine-----
De : rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] De la part de Mark S. Waterbury
Envoyé : jeudi 2 avril 2009 15:54
À : RPG programming on the IBM i / System i
Objet : Re: OVRDBF from an RPG?

Hi, David:

I suspect that this approach will continue to cause you
"grief" if you still have a "mixed" environment, with some
programs running in their own activation groups, and others
running in the *DFTACTGRP, etc. ... :-o

It sounds a lot like the situation where companies have
multiple members in their database files and need to issue
OVRDBFs to point to the correct member, depending on some
criteria in the application.

_*SUGGESTION*_
Eliminate the use of multiple libraries (or multiple members,
for those using that approach) by adding a new field (column)
to the relevant database files (tables) where that field
contains the equivalent of the library name (or member name),
and this becomes part of the "key" for those tables... That
way, the applications can just keep the files open all the
time, and select the relevant records "by key" ...?

This might involve "a lot of work" to get from where you are
now to where you want to go ... but it should greatly
simplify things in the long run.

All the best,

Mark S. Waterbury

> David FOXWELL wrote:

Hi,

I've another problem with files with the same names in

different libraries.

I have a Procedure1 in Module1 that calls Procedure2 in

Module2. Procedure2 opens implicitly a file F2. Then it calls
Procedure3 in Module3 which opens a file F3. It's possible
that other procedures are called, opening files in this same,
cascading manner.

So after my first call to Procedure2, I'll have Files2 and

3 open when control returns to Procedure1.

On my next call to Procedure2, I may want Files2 and 3 of a

different library.

Could I just open and close my files in the beginning of

Procedures2 and 3, and issue an OVRDBF in Procedure1 ?

Would it work? Would I have to use QCMDEXC or is there an

easy API way?

Thanks.

--
This is the RPG programming on the IBM i / System i
(RPG400-L) mailing list To post a message email:
RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.