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)
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 are the steps to retrieve the records from Journal file...?
What is library list ?
I am working in session1 ans session2. In session1 3 jobs are running. In session2 2 jobs are running. How many LDA and temporary files will be created?
What is difference between CAT, TCAT, BCAT?
How to add 99 menu (page down) option in menu creation..
can you display a empty subfile?
What is source physical file?
what is externally described file ?
What is the use of L specs in RPG?
how to create physical file
What is SFLSIZ ?
A phisical file has two fields like 1) Account No(10,0) 2)Phone No(15,0)Unique on both fields?Please give me the answer for this?