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 |
What are the different types of access paths maintained on the file?
What are the types of Signature validation?
What the purpose of the keywords FIFO, LIFO, FCFO?
how you will know whether you are in sfldrop or sflfold mode?
when you are defining a flat file in your program in f specs which format will you specify?
What is SFLPAG
How many MONMSG commands can declare in a CL program?
during input operation which indicator position is seton if there is a record lock?
What is Folder?
What is Data Area?
how we lock a pf???? what are the parameters used in this command.how we understand whether an object is locked or not?? using command .....we have to use *PSSR? and trough *status..how??.if we give an eg to me???pls answer me anyone..
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.