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
- 9215 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how do you specify page overflow indicator for printer files in rpg?
What is file information data structure(infds) in as400?
If i change any file through application after entering data , how to check which file is updated through applications . For call stack we takes esc 3 then we chose 11..But What is answer of below qtn..?
define the purpose/use for sflrna?
Why we have multiple data types in As400 and why we use numeric, packed, decimal, zoned the basic difference between this?
is there any way to dynamically merge other html scripts into a given html?
how to define global parameter in ile ?
how can you detect and handle a record lock situation?
To Add A File To The 'file Selection' Option Of A Query, The Function Key To Be Pressed Is?
what is subfile?
. How to know why the OPM job is in MSGWAIT state?..WHAT COULD BE THE REASON FOR it?
how can u check no of records in a file?
give three main purposes of file specification ?
in conjunction with what other keyword must ovrdta and ovrata be used?
How to debug a batch job when it is in messagewait(mswg) status. I know the steps for batch ebugging, but im confusing with when we submit any job for batch debug we put in held state. So here also do same thing or any other way?
