Interested to Buy Any Domain ? << Click Here >> for more details...
Which is better LF or OPNQRYF ? When should we use LF and
when should we use OPNQRYF ?
- 5 Answers
- 17532 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vaiv20
It depends on the situation. Whenever any update, delete or
add is performed on file, access data paths to the logicals
are also updated hence if data is very huge in the file it
will take toll on system response time for doing the
update, delete or add operation.Hence take a call based on
this consideration. Also, if you want to create a view on a
physical file for not so frequent use its better to use
OPNQRYF.
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / reecha
If the no. of records to be filtered is less then OPNQRYF
is better option then LF becoz it create temporaray ODP
only & overhead on system is less.
if teh records to be filtered out are more ten LF sud be
created
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / adarsh
It depends on the frequency of accessing the records from
physical file. If records are huge and frequency of
accessing them is high then go for LF , but if records are
huge or less but Frequency is minimal then go for QPNQRYF
as it does not create a permanent object.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / arun
according to me
lf is used for upd(non joint lf),view,
in this path is permanent it occupies more spaces
openqryf is used for temp path ,
it can access 5 files
so opqryf is better
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / m nihar
OPNQRYF is better then LF. Coz , OPNQRYF creates temporary
access path but LF creates permanent objects.
When we use all fields of your file then we use OPNQRYF for
temporaryly use. But when we use some choosen fields from
file then we use LF.
| Is This Answer Correct ? | 2 Yes | 10 No |
Diff B/w ref and reffld?
what is the purpose of DMPCLPGM IN CL?
What is acronym of RPG?
what is the necessary keyword for non-join logical file?
How we can delete all the Logical File of a Physical file in one instance ?
What are the two main attributes, which govern the execution of a job?
what if my system I runs with system value qccsid 65535?
How to add 99 menu (page down) option in menu creation..
What is a job log?
what are the three line types in rlu ?
what is message file?
How can you check the existence of object in a system?
RPG400 
