RE: OVRDBF FILE(myfile) TOFILE(myfile)

"A time before libraries existed" would have to be reference to some special
environment (such as S36E). Even at Release 1 of System/38 CPF, libraries
(including library lists et al, but not including *CURLIB) were an integral
part of the system.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"As lousy as things are now, tomorrow they will be somebody's good old
days."
-- Gerald Barzan

But then you'd have to have OVRDBF FILE(PFILE1) TOFILE(LFILE1)

A coworker seems to think that they are remnants of a time before
libraries existed. Like when was that?!
The original command would have been perhaps OVRDBF FILE(MYFILE)
TOFILE(MY.FILE). Subsequently, the '.' have been taken out.

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Loyd Goodbar
Envoyé : jeudi 2 septembre 2010 14:17
À : Midrange Systems Technical Discussion
Objet : Re: OVRDBF FILE(myfile) TOFILE(myfile)

One reason may be to force the use of a particular logical file.

For instance, an RPG program is coded over PFILE1. Later, a
logical file
LFILE1 is created with keys matching the RPG program's logic.
Instead of changing the RPG program to use LFILE1, perform an
override instead.
Assuming PFILE1 and LFILE1 have the same format level
identifier, no change is required to the RPG program and you
gain a performance increase due to the access path.

Note, for SQL RPGLE programs, overriding a file to take
advantage of indexes is unnecessary. As long as the RPG
program's SQL references the base table, the SQL runtime will
use any new indexes automatically.

Does the FILE() parameter have a library, such as
FILE(OTHERLIB/LFILE1)?
Cross-library logical files are not a best practice, but
sometimes happens if management requires a strict separation
between vendor code and in-house code.

--Loyd

On Thu, Sep 2, 2010 at 3:50 AM, David FOXWELL
<David.FOXWELL@xxxxxxxxx>wrote:

All,

I'm seeing a lot of old clp's doing this command before

calling an rpg

program. There are ovrdbf's for each of the files specified

in the rpg.

Can anyone explain the reason for doing this?


--
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.

--
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.

--
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.