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
- 17539 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 |
What are the two types of read performed on data queues?
where will control be passed after the execution of the *pssr subroutine if the factor2 of the endsr is blank ?
1.What is the difference between regular join logical file and non join logical file? 2.what are the nessasary keywords for non join logical file
what is sflrolval?
how do u compile rpgle program?
What is the purpose of OPNQRYF (Open Query File)?
What is Folder?
what is rpg ?
define the purpose of the *cat function?
how can a cgi check whether an ifs object is available?
how many files can be defined in f specs?
what is the function of cpysplf command?
RPG400 
