what is the necessary command needed before OPNQRYF and why?
Answer Posted / abhishek bajpai
It is not mandatory to use OVRDBF(*Yes) before OPNQRYF. You
can still use OPNQRYF without OVRDBF.
But here the pupose of the OPNQRYF won't be solved.
Opnqryf creates its own 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
records in to runtime file and use that file to read in
program.
| Is This Answer Correct ? | 20 Yes | 2 No |
Post New Answer View All Answers
Explain mdt?
what is program status data structure?
How do u design a physical file, when you have 2 Unique fields like for eg in A student file student ID and student examination no both are unique
what is the rpg system?
what is *place and *auto keyword in prtf ?plz explain
how do I preserve and clean the array?
How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...
what is kids-rpg?
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
how do I declare a table or array in rpg iv?
what is the use of sflnxtchg?
explain sflclr, sflend, sfldlt, and sflcsrrrn?
do you use message subfiles? What are the necessary keywords required coding a message subfile?
what was the robotech rpg?
What is file identifier where we can use?