RE: ovrdbf, opnqryf, & bound modules

Scott, 

Many thanks.  It's one of those things where I know you have to do an
override before an open, but for whatever reason my mind wasn't looking
at that and saying that the override is no longer needed after the open.
That worked.

Gratzi, 

Kurt Anderson
Application Developer
Highsmith Inc

-----Original Message-----
From: midrange-l-bounces+kjanderson=highsmith.com@xxxxxxxxxxxx
[mailto:midrange-l-bounces+kjanderson=highsmith.com@xxxxxxxxxxxx] On
Behalf Of Scott Klement
Sent: Friday, December 09, 2005 2:37 PM
To: Midrange Systems Technical Discussion
Subject: Re: ovrdbf, opnqryf, & bound modules


> I thought that removing the Share(*Yes) would keep the override only 
> in the current module, but when I did that, the file wasn't reflecting

> the result set from the OpnQryF.

SHARE(*YES) means that you want to share the ODP.  In other words, when
OPNQRYF positions to a particular record, your program will read that
record, because they're sharing the same open data path to the file. 
Without this setting OPNQRYF won't have any affect on your program.

It has no affect whatsoever on which modules the override applies to.

> One option for the override to not propagate to the Maintenance module

> is for me to create a new logical for that program to use.
> But I was hoping there was another answer.  Can I somehow scope the 
> override to just the Selection module?

Why not simply DLTOVR to delete the override before calling the 
maintenance module?   The override is only necessary when the files are 
opened (either with the OPEN op-code, or automatically when the RPG
cycle gets to the right place).  Once the file has been opened, the
override is superfluous, and it's save to use DLTOVR.  That way, the
override won't affect anything else by mistake.

Another alternative is to put the maintenance module in a separate
program or srvice program, so that it can be run in a different
activation group. 
Then you can use OVRSCOPE(*ACTGRPDFN) on the OVRDBF command, and it'll
only affect the actgrp that it was issued from.

> Can I override the file again, and when I delete that override the 
> previous override will take over?

If the overrides are at different levels, this'll work.  If they're at
the same level, the new override will replace the previous one.
--
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.