can any one pls tell me some differences between a LF and
command OPNQRYF?
- 3 Answers
- 11551 Views
- Accenture, Cognizant, eFunds, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How to know the particular record in pf with out reading?
What is the interactive job? What is the batch job? How to change the batch job to interactive job?
I have a pf, it contains 5 members, how to access particular member data from logical file?
There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.
How to read a pf in reverse(from last record to first) using cl?
How to index LF by relative record no (RRN)
How to retrieve a physical file after deleting that?
What is the use of member in pf?
What is FORMAT keyword and its use?
Can we concatenate fields in physical file? If yes how can we do?
What is the primary file?
What is the purpose of the chain and setll and setgt?
In a CL Program after executing a SQL SP how to receive a Output value from the SP. Just to make it clear I am sending 2 input and 1 output parameter to the SQL Stored Procedure. Now while receiving it output parm it is failing.
What is the difference between access path and open data path?
What is the interactive job?
