Can we use OVRDBF command without using of OPNQRYF ?
Or can we use OPNQRYF command without using of OVRDBF
command ?
Answer Posted / bharat
OVRDBF can be used separately without opnqryf to override
the attributes of file.
Now, OPNQRYF without ovrdbf, is also possible:
opnqryf creates the open data path and to share the same
data path in a program we use ovrdbf share(*yes), if we do
not use ovrdbf, then program will have its own ODP, so it
will read the file from begining on which query has been
run. So, OPNQRYF selected records will have no importance.
So, we need to use CPYFRMQRYF command and put the selected
recoreds in to runtime file and use that file to read in
program.
Is This Answer Correct ? | 43 Yes | 3 No |
Post New Answer View All Answers
how do you specify page overflow indicator for printer files in rpg?
In RPG How to read a records from a file without using read opcodes?
what is the difference between seton lr and retrn?
in conjunction with which statements can orxx and andxx conditions be used ?
what is maximum number of arrays allowed in rpg?
define what a data queue is along with a brief example of what it may be used for?
How can we change the uppercase to Lowercase in RPG?
what is a query can be run in which mode?
what are the different opcodes available in rpg for database access ?
which type of object is used in db2/400?
what is the use of dspatr(mdt) keyword?
when do you explicitly open files and close files in an rpg program?
what does check opcode do ?
an access path may be in which sequence?
what are different types of substems?