when would you prefer logical file than opnqryf?
Answer / 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 |
A phisical file has two fields like 1) Account No(10,0) 2)Phone No(15,0)Unique on both fields?Please give me the answer for this?
what are the different types of variables available in cl?
What is a Library in AS/400?
what are dds required for subfile?
difference between sflrcdnbr and sflnxtchg?
Any change in service program we write binder language to allow signature change,What is the maximum number of signature change allowed in RPGLE?
3 Answers Syntel, Tech Mahindra,
If login Screen has been modified by adding current date to be displayed. What Step to be followed to Keep that date as Current date Note: If no steps taken then it will display only the compilation date
Hi friends.. i want to be a IBM MainFrame Professional.. can any body tell me what is requirement for that... i m just BA, MA, and have simple diploma in Computers. what is pre-requisite.
diffrence between rename and prefix
What is an authorization list?
How to write a password mask program in as400? like the password which i type should be displayed as '*****' r ###### which the user wishes to dispaly if u could help me with url r the solution in written code this will help me
what are the limitations of cl (compare to rpg) ?