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
define data structure?
I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.
records can be read/update/deleted with which file?
when do you explicitly open files and close files in an rpg program?
how do you specify page overflow indicator for printer files in rpg?
what if my system I runs with system value qccsid 65535?
is it there an easy way to determine if an html section is available to issue a wrtsection upon?
what is the use of jdftval in join logical file?
What is program status data structure(psds) in as400?
Which command is used to replace CDUP command in FTP IF i WANT TO USE SFTP?
how can I control the way a remote browser uses its cache?
what is the maximum number of subroutines allowed in rpg?
How can we change the uppercase to Lowercase in RPG?
Can we debug the MSGW JOBS?
How to convert a spool file to PDF file in AS400?