Which is better LF or OPNQRYF ? When should we use LF and
when should we use OPNQRYF ?
Answer Posted / 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 |
Post New Answer View All Answers
the maximum number of subfiles that can be active for a single file is ____ .
which single rpg opcode performs both setll and reade?
What is the as400 called now?
what is subfile?
what are the limitations of cl (compare to rpg) ?
what does vldcmdkey means?
what is meant by object lock requests,held locks and locks waiting to be applied(wrkobjlck) why should we apply for locks.Please explain sir.
What is file access opcodes?
when would you prefer logical file than opnqryf?
difference between sflrcdnbr and sflnxtchg?
i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.
what does opcode post do ?
describe the difference between the dowxx and douxx operations?
http default port 80 is used by some other production http service. How can I create an http instance on another port to run cgidev2 and my future cgi developments?
Explain The Keywords Edtcde & Edtwrd?