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
- 8161 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 |
writing an sql statement from selecting records from two files using single statement and nested select statement.
To Add A File To The 'file Selection' Option Of A Query, The Function Key To Be Pressed Is?
Explain this error: "all record formats for externally-described file abcd ignored or dropped due to error; file ignored."?
how to write *pssr ?
at what level s,o are defined and what they will do?
What is difference between CAT, TCAT, BCAT?
Can an indexed file be accessed in arrival seQuence in RPG program ?
define the purpose of the *cat function?
pf named karthik 3members jan feb mar cmd must executed create mbr ar ap
what is sflrolval?
Describe about Query/400?
what is message file?
RPG400 
