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


Please Help Members By Posting Answers For Below Questions

what is the command used to invoke rlu ?

1178


how you will find an error which is not in the first page of the subfile without using rolldown key?

564


how to get the cursor position?

720


can you specify a display file to be used in the following modes input,output, or combined modes ?

950


what is a primary file?

1053






how do you pass parameters in cl?

1064


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...

1919


What is the use of jdftval in as400?

916


what is the sequence when using cursor?

607


What is the maximum number of subfiles that can be specified in a display file?

1153


why is the declare cursor statement is used for?

632


what is the maximum number of records you can specify in a display file?

1131


how to toggle between single line and multi - line display of a particular record in a subfile?

1092


what is match field indicator?

1029


Can level check error occur if we do chgpf?

778