when would you prefer logical file than opnqryf?
- 1 Answers
- 1601 Views
- IBM, I also Faced
- E-Mail Answers
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 |
what the purpose of ovrdta, ovrata keywords?
Explain this error: "all record formats for externally-described file abcd ignored or dropped due to error; file ignored."?
what is the maximum number of subfiles that can specified in a display file ?
I am a fresher. I got project on AS 400. Can any body suggest the best book for learning of it.
Job is running in production 24/7 how do u debug that running job ?
Hi Friends, I need immediately answer for this: Senario is that,I am selecting records from the display and window subfile on the basis of Reason Code and some more fields but spool file not showing the same records which i have selected by display and window subfile. Q.What could be the causes(resons)to not show records properly (just selected in the display file and Window subfile)according the selection criteria of the records. Q.What would be the solutions to show records properly in the spool file just as selected in in the display file and window subfile according to the selection criteria.
a program variable coded in an embedded sql statement is referred to as?
What is the purpose of CHGPF (Change physical file) command?
how can i get the cursor position in display screen to to display my window?
What is source physical file?
what is a logical file?
If i change any file through application after entering data , how to check which file is updated through applications . For call stack we takes esc 3 then we chose 11..But What is answer of below qtn..?
RPG400 
