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
Hi,Please give me the the answer for these quesitons? 1.what is IFS and ICF and RAPE amd DISKET fils? explain with example please? 2.What is the difference between POST AND SPACE OPCODES? 3.Can anybody tell me default printerfile command and object type?
how to develop some simple graphs (bar charts) using just html?
writing an sql statement from selecting records from two files using single statement and nested select statement.
how do you read changed records backward in subfile?
maximum number of subfiles that can defined in a rpg program for one display file is?
how do you specify page overflow indicator for printer files in rpg?
how you get the relative record in a subfile in which cursor is located?
What is the difference between iter and do? We know both are used to execute set of statements repeatedly, but what is the main difference?
define the purpose of the leave operation?
what is the use of dspatr(mdt) keyword?
define a shared access path?
how do you know that records are locked?
what is a physical file?
what is the purpose of indicators in rpg?
define the rcvf command?