Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main use of OPNQRYF ?? in that query why we can
use OVERDBF and in that OVERDBY why should we use SHARE(*YES)
- 2 Answers
- 9251 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kapil kumar
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 ? | 19 Yes | 0 No |
Answer / swarn
It also depend on how the PF was created initially. At the time of creation of PF,if SHARE parameter is specified as *YES, we do not need to specify OVRDBF Share(*yes).
By default it is *no when we create a PF.
| Is This Answer Correct ? | 1 Yes | 0 No |
what is the use of data structures?
Q. Soppose one job is running in a batch mode for long time now i want to kill(end)this batch job.How you will achive this?
What is a job log?
Using %check we are checking monika in mona what is output? What is %SCAN?
I have SQLRPGLE program in which there are some update statements which executed correctly. there were no errors run time. Once the program gets over, the file was not updated with the new values. What might be the reason?
Can we add or remove the module object from service Program..and how...?
What is the use of jdftval in as400?
records can be read/update/deleted with which file?
what are different types of substems?
Describe about Query/400?
How to see active jobs of the system.
What is the maximum number of subfiles that can be specified in a display file?
RPG400 
