when would you prefer logical file than opnqryf?
Answer Posted / pratap thakur
The physical file you are working with very large, creating and using a logical file will allow an application to perform faster than using an open query file.Since access paths created by open query files are temporary, applications that use an access path frequently will be more efficient using a logical file, since the access path will not have to be rebuilt every time the file is open.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the use of dspatr(mdt) keyword?
The content of Physical file is as below: hfcftp wruquief SENDPASV 0 CDUP ASCII GET 01100901.CSV ramndk/ECP505.EC0110090 (REPLACE QUIT Thw above commands will get executed when we call STRTCPFTP from CL program.... Now if I want to use SFTP what can be the solution? plz reply in detail....Thank you for ny help... I m using RPG/ILERPG to download...
how many types of display are available on as/400 for user interaction?
What is the use of jdftval in as400?
How to convert a spool file to PDF file in AS400?
which are the member types which seu supports?
when do you use f-spec. Continuation line ?
what are dds required for subfile?
maximum number of subfiles that can defined in a rpg program for one display file is?
what is the function of cpyf command?
if we tried to move year part of *iso date into a field of length 3, what will happen ?
how can I predict the performance of my cgis?
how you get the relative record in a subfile in which cursor is located?
how to write code for singlepage in sqlrpgle with update ?
a multiple format logical file is also known as?