Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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)

Answers were Sorted based on User's Feedback



what is the main use of OPNQRYF ?? in that query why we can use OVERDBF and in that OVERDBY why sho..

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

what is the main use of OPNQRYF ?? in that query why we can use OVERDBF and in that OVERDBY why sho..

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

Post New Answer

More IBM AS400 AllOther Interview Questions

What are the steps to retrieve the records from Journal file...?

1 Answers  


What is library list ?

1 Answers  


I am working in session1 ans session2. In session1 3 jobs are running. In session2 2 jobs are running. How many LDA and temporary files will be created?

3 Answers  


What is difference between CAT, TCAT, BCAT?

1 Answers  


How to add 99 menu (page down) option in menu creation..

0 Answers  


can you display a empty subfile?

0 Answers   IBM,


What is source physical file?

1 Answers  


what is externally described file ?

1 Answers   IBM,


What is the use of L specs in RPG?

1 Answers  


how to create physical file

1 Answers  


What is SFLSIZ ?

1 Answers  


A phisical file has two fields like 1) Account No(10,0) 2)Phone No(15,0)Unique on both fields?Please give me the answer for this?

3 Answers  


Categories