what is the necessary command needed before OPNQRYF and why?
- 5 Answers
- 24741 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abhishek bajpai
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 ? | 20 Yes | 2 No |
Answer / sumit gupta
Hi guddu............
OVRDBF is not mandatory before doing OPNQRYF. OVRDBF is
only used to share the open data path within the calling
program(i.e we can use the selected records from OPNQRYF in
further program whose call is being made after
OVRDBF+OPNQRYF).
But is we dont use the OVRDBF command then open data path
will not be shared and if we done the RCVF on that file
after OPNQRYF(WITHOUT OVRDBF) then the selected records
from OPNQRYF will not be used and this RCVF will process
all the records from that file.
OVRDBF command is used just to share the open data path (By
specifying SHARE(*YES).
We we want to use the selected records from the OPNQRYF in
our further programs which call after this CL then we can
use CPYFRMQRYF command to copy all the selected records
from this OPNQRYF and then RCVF on this new file(which has
got generated by CPYFRMQRYF).
| Is This Answer Correct ? | 11 Yes | 2 No |
I have a RPG program of 100 Lines and first line is to SETON indicator LR. Will the program execute rest of the 99 Lines?
WHAT IS MEANT BY SIGNATURE VAILOTION ERROR
1) How to define keyed file in CL pgm. 2) How can i read particular records in CL pgm from database file.
can any body correct the following code? Following a procedure which returns the maximum of two numbers.Correct the following code. P GETMAX B D GETMAX PI D NUM1 35 0 D NUM2 45 0 C IF NUM1 > NUM2 C RETURN NUM1 C ELSE C RETURN NUM2 C ENDIF P GETMAX E
How we will read call stack?
wat is meant by hidden field , why it is used?
how do I preserve and clean the array?
Can anybody tell me in which scenario we have to use SQLRPG .(Embeded SQL)....?
what is data area and how it is used in rpg program ?
Hi, can any one tell me :IN CASE OF SINGLE PAGE FILE HOW WILL I LOAD THE PREVIOUS PAGE WITHOUT THE USE OF SFLCLR INDICATOR ?
how we retrieve records without using key field (ex:name) from Physical File through RPG in as/400?
what is plat file?
RPG400 
