Which is better LF or OPNQRYF ? When should we use LF and
when should we use OPNQRYF ?
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 |
(1)In Cl Program,Are PGM and ENDPGM mandatery Keywords or not .If yes, please tell me why these keywords is necessary. (2)If we will not define these two keywords (PGMand ENDPGM) then any error will be come or not.
What is the difference between a Physical File & a Logical?
28 Answers Accenture, ACS, IBM,
Can fields be concatenated INa logical file level?
what if my system I runs with system value qccsid 65535?
define the purpose of the %sst function?
what is clile code get last digit in numarice value
How many primary files allowed in a program?
can we use ASCII ,CDUP,SENDPASV commands in SFTP?
what is the disadvantage of using global variable?
using dfu, user will be able to ___________ from physical file?
what are necessary keywords to code message subfile?
Diff B/w ref and reffld?