what are the main functionalities of ovrdbf ?
what are the main functionalities of ovrdbf ?
Software/Hardware used:
Software/Hardware used:
ASKED:
August 20, 2008 6:24 PM
UPDATED:
August 21, 2008 4:38 PM
Answer Wiki:
OVRDBF is used to redirect input/output
The RPG or COBOL program uses FILEA but you need it to
- use FILEB (which is structurally the same)
- use LIBB / FILEA
- use the results of an opnqryf as if it were FILEA (be sure to include SHARE (*yes)
- use a specific member in a multi-member file
_____________________________________________________________
The Override with Database File (OVRDBF) command is used to (1) override (replace) the file named in the program, (2) override certain parameters of a file that are used by the program, or (3) override the file named in the program and override certain parameters of the file being processed. Parameters overridden by this command are specified in the file description, in the program, or in other previously issued file override commands. This command applies to physical files, logical files, and distributed data management (DDM) files.
To override (replace) a file named in the program, specify the name of that file in the FILE parameter, and specify the name of the file that overrides it (the file to be processed by the program) in the TOFILE parameter. The other parameters of this command can be used to override parameter values contained in the file description of the overriding file.
To override only certain parameters of the file named in the program, instead of replacing the entire file, specify the name of the file in the FILE parameter and specify the *FILE value for the TOFILE parameter. Then use the other parameters of this command to override specific parameters of the file. Parameters that are not specified do not affect parameters specified in the file description, in the program, or in other previously issued file override commands.
you can have more information on this on following link for <a href="http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/cl/ovrdbf.htm">OVRDBF</a>: http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/cl/ovrdbf.htm
To see all answers submitted to the Answer Wiki: View Answer History.
one more link on ovrdbf is: http://publib.boulder.ibm.com/iseries/v5r1/ic2924/index.htm?info/cl/ovrdbf.htm
A long time ago, IBM only allowed 8 character file names in an RPG program while at the same time allowing 10 character file names on the system. If your program needed to open a 9 or 10 character file name, an override was required to establish a link between your program and the desired file.
That was the most common use I saw in earlier days.
For example, OVRDBF FILE(ABC1002L) TOFILE(ABC1002L9)
File ABC1002L did not exist but the override pointed to the file that did exist.
Believe it or not, we also had to establish the same override before compiling the program.
It was a big pain.
We were very happy when IBM allowed 10 character file names in our programs.
Bob Cozzi just wrote an informative article about OVRDBF.
It contains some good stuff.
http://systeminetwork.com/article/passing-file-names-rpg-iv