Interested to Buy Any Domain ? << Click Here >> for more details...
can any one pls tell me some differences between a LF and
command OPNQRYF?
- 3 Answers
- 12595 Views
- Accenture, Cognizant, eFunds, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
can any one pls tell me some differences between a LF and command OPNQRYF?
3 Answers Accenture, Cognizant, eFunds,
WHAT IS THE DIFFERENCE BETWEEN 'COLHDG' AND 'ALIAS'?
how to add a new field to a file without compiling it?
Can anybody tell why Journalling is compulsary before Commitment Control?
how to update physical file using logucal file with example
Why journalling is compulsory before commitment control?
How we can't update join logical files?
what is open data base command
1 Answers Active Brains, Cognizant, CSC, CTS,
Why we create the Physical File Member?
i have a PF,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in PF
how can i know logical file belongs to which physical file without source?
If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by doing the run query of the file? if not how can we see the impact of these keywords.
RPG400 
