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

Q.1 how to implement the commitment control. 2.how to control commitment control from external program.

7 Answers   IBM,


Where the QTEMP library will get created? if the the answer is QSYS, then howcome more than one job can create same library name(QTEMP) in QSYS? what is the uniqueness of QTEMP? For example, run the below command in different workstation WRKOBJ QSYS/QTEMP And take 8 in the option to check the description. both will have different info. so where(which LIB) exactly the QTEMP is stored?

2 Answers  


What is the primary file?

0 Answers  


What is the interactive job? What is the batch job?

0 Answers  


hi iam very new to as400. i had created one physical file can any one tell command to enter data in to that

9 Answers   Encore,






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

0 Answers  


A pf containing 100 records... my query is how to display from 11th record in the pf?

3 Answers  


Why journalling is compulsory before commitment control?

1 Answers  


What is the interactive job?

0 Answers  


How can i retrieve city while my i have one field address length 60 but i don't know what where is city in this field ?

4 Answers  


What is the use of member in pf?

0 Answers  


how to see number of logical files depending on a pf?...can we declare more than 20 logical files from a single pf? is it possible

4 Answers   ocbc,


Categories