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 does union file maintains record formats?
Can we debug the MSGW JOBS?
how can database records be read without lock ?
define data structure?
define what a data queue is along with a brief example of what it may be used for?
Difference Between Skip Before & Space Before?
can you specify a display file to be used in the following modes input,output, or combined modes ?
What Does 'sr' In Columns 7-8 Of C Specs Mean?
when do you explicitly open files and close files in an rpg program?
how to validate input values in display file ?
What Does Lokup Does In Tables & Arrays?
what key word is used when screen is re-display?
What Is The Error If We Don't Get Login Screen?
difference between sflrcdnbr and sflnxtchg?
what if my system I runs with system value qccsid 65535?