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 |
Hi,while writing a program, what is the mandatory specification using rpg/400 (in7 specification)?And please tell me what is the difference between SCAN AND CHECK opcodes?can any body tell me in real time senario?with example?
define what a data area is along with a brief example of what it may be used for?
what is *iso date format?
what does check opcode do ?
where can you specify an indicator in lokup operation?
What is the exact difference between Service Program and Binding Directory?
why we sometimes use same file name in FILE and TOFILE in OVRDBF and sometimes different??please tell
What is a Join Logical File, Can it be used for Update ?
can we retrieve dspf source?
Hi,Can any body give the code for the below mentioned quetion.?Im trying to get coding in with easily inderstanding.Plese give me the coding for this? 1.How would you achieve this requirement with out using RPG/RPGLE pgm,but by using only CL?Read a database file and display file contents on the screen when enter key pressed the next record should be displayed on screen.When the last record is reached or when F3 key is pressed the program should exit if the file is empty,a message should be displayed indicate that there are no records to display. Database file Name=EMPDBF Fields in EMPDBF to be displayed on screen Employee Number- EMPNUM(5,0) Employee Name- EMPNAM(30,A) Employee Address-EMP ADDR(50 A)
What Is The Purpose Of The "n" In The Following Calculation Specification?
What is the purpose of OVRATA keyword ?