when would you prefer logical file than opnqryf?
- 1 Answers
- 1374 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 are the different opcodes available in rpg for database access ?
How I can read and display three fields in the record format DSPFM1 of the display file,while one field(using in one file) is NAME which is Key field in field reference file and another two fields are AGE and ROLL NO are using another file. Please send me coding part.
How to position the cursor on a display file at a desired location.
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.
i have two pfs it contains "Status" fields in the same name "status in both the pf's...But i used the same name in display file...when i enter a status thru disp file it willbe added to pf1...so i want to rename "Staus " field in pf2 through program...............wat will do..give coding?
why is as/400 called object oriented machine?
What is the difference between Physical and Logical files ?
what is primarykey?what is difference between primary key and forign key?
Which of the following operations does NOT zero the field FLDA defined as 4,0? C MOVE *ZEROS FLDA C Z-ADD *ZEROS FLDA C Z-ADD 0 FLDA C MOVE *ALL'0' FLDA C SUB FLDA FLDA C MOVE '0000' FLDA C CLEAR FLDA C MOVE *BLANKS FLDA
Q.How primary file can be defined in RPG/400?Please write the senario with opcode specification?
WHAT IS ACTIVATION GROUP IN ILE?
10 Answers Accenture, HSBC, TCS,
What is array in as400? What are the types of array?
RPG400 
