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
- 17271 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 |
how can a cgi check whether an ifs object is available?
How many record formats can you have in a Physical file and in a Logical file ?
list some of the commonly used commands for debugging?
How to reverse a string using RPG?
what does the opcode free do?
Hey, What is the difference between SCAN,CHECK,XLATE OPCODES? please give me the answeres with example in real time senario?
how many printer files maximum can be used in single rpg program?
I am a fresher. I got project on AS 400. Can any body suggest the best book for learning of it.
describe the difference between the dowxx and douxx operations?
WHAT IS THE DISPLAY CMD FOR DATAQ, HOW IT CAN BE USED?
how does union file maintains record formats?
What Is The Object Type Of Pf, Lf, Printer File & Display File?
RPG400 
