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.