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)
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
what is the difference between seton lr and retrn?
To Add A File To The 'file Selection' Option Of A Query, The Function Key To Be Pressed Is?
I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.
maximum number of subfiles that can be active for a single file is?
define the purpose of the *cat function?
How to add 99 menu (page down) option in menu creation..
what is rpg fixed logic cycle?
What is binder language ?
can you specify a display file to be used in the following modes input,output, or combined modes ?
How can we update a specific field in RPG?
how to develop some simple graphs (bar charts) using just html?
what does the opcode free do?
explain the difference between defining subfile and message-subfile?
how do you read changed records backward in subfile?
what does opcode post do ?