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
- 17122 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 |
A join logical file has how many record formats?
What are the steps to retrieve the records from Journal file...?
What is the draw back of Procedures? why we are going to Modules?
why do we use readc? What is sflnxtchg?
What is the purpose of SFLNXTCHG keyword in a subfile?
What is logical file in as400? What are the types of logical file?
when would you use or not use this approach?
whare we can use IN AND OUT AND UNLCK opcodes?please can any body tell me in real time senario with example
how to change job priority when it is running in sub system ?
what is sflrolval?
How many types of jobs?what is difference between interactive and batch and submited jobs?
what are the types of errors available in rpg IV or 400.Like decimal data error,sessional error or device error etc...means important error occurings,ie to find out suddenly???pls give answ if u know?Pls give the answer 1,,,,,,,to 12.........ie how it will happened like...for eg if a file is not closiing ,,,like this error is happened... if sufficient data is not in a pf to write in a display file. or sfldsp is not "on"......sessional or device error occured...like this give details all 1 to 12 errors (syam..)....give details PLsssssssssss?
RPG400 
