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
how do I declare a table or array in rpg iv?
Hi Viewers can any body explain me how to update and ahange the already existed data in physical file using subfile ? please explain me with the code if possible?
how does the rpg element work?
What is the difference between iter and do?
When it is desirable to describe files Internally?
how do you use commitment control in rpg?
We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?
if there is a module object , how to find the program object for this module object.Assume the module object name and program object name is not same.
How would display prime numbers using CL program?
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400
What is ment by record level identifier?
How to call one program from another program in RPG? please help me with the code
can I touch the array during treatments?
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...