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...


can any one pls tell me some differences between a LF and
command OPNQRYF?

Answers were Sorted based on User's Feedback



can any one pls tell me some differences between a LF and command OPNQRYF?..

Answer / vaiv20

LF creates a new object in the system while that is not the
case for OPNQRYF.
LF creates a permanent data access path to the physical
file that will be updated as and when and add,update and
delete operation is performed on file Whereas OPNQRYF
creates a temporary access data path that is shared by high
level pgm for further processing of recs in file.

Is This Answer Correct ?    30 Yes 0 No

can any one pls tell me some differences between a LF and command OPNQRYF?..

Answer / senthilkumaran

The main difference is : Logical file creates permanent
object on the system. OPNQRYF creates temporary access
path.

Is This Answer Correct ?    16 Yes 0 No

can any one pls tell me some differences between a LF and command OPNQRYF?..

Answer / amit

I agree with Vaiv20. Just want to add that OPNQRYF is used
with keyword Share(*Yes) and that's what makes the ODP
avaiable to high level pgms.
Also the usage of OPNQRYF is for adhoc jobs that are
executed once in a while whereas LF is used in case where
the ODP is going to be used pretty regularly. So LF object
would be prefered when the usage is going to be regular
where as OPNQRYF would be good where the job is going to be
once in a while.
LF would make the job faster compared to OPNQRYF though ti
depends on what kind of maintenance option you use for LF.

Is This Answer Correct ?    9 Yes 0 No

Post New Answer

More DB400 Interview Questions

what is the intractive job? what is the batch job ? how to change the batch job to interactive job?

2 Answers   Four soft,


When u create a PF and did not fill up Maint parameter, then by default which access path will the system take & why

2 Answers   HCL,


What is the purpose of the chain and setll and setgt?

0 Answers  


How to add a field to a PF and compile it without loss of data?

7 Answers  


what is error handling concepts in cl

3 Answers   Active Brains,


Is it possible to create a logical file whose Physical file is not in same library?

6 Answers  


How to read a pf in reverse(from last record to first) using cl?

0 Answers  


How to find the list of source physical files in a library?? Is there any way to get a list??

5 Answers   Infosys,


How to know the perticular record in pf with out reading?

2 Answers   Cap Gemini,


What is the use of member in pf?

0 Answers  


CRTDTA AND CRTARA should be used along with?

2 Answers  


There are six records in a file and we are going to update that records and used commit operation when it complete the update but suppose when it updating the third record,a error occured and operation failed.Is previously two records will be update or whole operation will be rollback? Please confirm it.

2 Answers  


Categories