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
- 9348 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 |
how can we run a batch job?
what is the purpose of dynslt keyword?
how can i get the cursor position in display screen to to display my window?
How many MONMSG commands can declare in a CL program?
How to create a user defined (general) data area?
explain the difference between defining subfile and message-subfile?
what are the types of errors available in rpg IV or 400.Like decimal data error,sessional error or device error etc...means important error occurings,ie to find out suddenly???pls give answ if u know?
what is the version of os/400 that we have?
What is library is as400? What are the types of library?
Show 2 ways to convert a date from YYMMDD to MMDDYY (MULT operation not acceptable)
What are Triggers?
14 Answers Ordain Solutions, Seabus Solutions,
i have two pfs it contains "Status" fields in the same name "status in both the pf's...But i used the same name in display file...when i enter a status thru disp file it willbe added to pf1...so i want to rename "Staus " field in pf2 through program...............wat will do..give coding?
RPG400 
