Interested to Buy Any Domain ? << Click Here >> for more details...
when would you prefer logical file than opnqryf?
- 1 Answers
- 2409 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 |
Difference between NOPASS & OMIT?
how can a cgi check whether an ifs object is available?
what is match field indicator?
Q.1.What is differences in STRDBG and STRISDB debugging commands? 2.Where we should use STRDBG and STRISDB Debugging commands?
I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.
WHAT IS FERERENTIAL INTRIGRITY ?
Is it possible to join the same file to itself ?
What is LEVEL CHECK?
what are the different opcodes available in rpg for database access ?
Can we add or remove the module object from service Program..and how...?
Q.How can more than two program be executed in batch mode through SBMJOB in CL PGM but the condition is that program must be executed one by one?Please wtite the senario? 2. IS it possibe more then two programs can be executed in batch mode and HOw it will be executed in CL program ,please write the senario?
How do you set the keywords SFLSIZ and SFLPAG if you want the subfile to dynamically expand?
RPG400 
