what is difference between random and sequence file access
Answer / naidu sekhar naidu
SEQUENTIAL FILE: 1)IF DATA IS ENTRY IN SEQUENTIAL ORDER
2)ACCESS IN SEQUENTIAL ORDER
3)MAIN ADVANTAGE REPORT GENERATION
RANDOM FILE: 1)IF DATA ENTRY IN SEQUENTIAL AS WELL AS RANDOM
2) SEARCHING IS MORE FASTER COMPARE TO THE SEQUENTIAL FILE
CORRECT ME IS AM WRONG U R FRIEND
Is This Answer Correct ? | 1 Yes | 2 No |
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
What is the default page size of buffer pools?
Which isolation level provides maximum concurrency?
What is cloudant database?
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
What does an outer join do?
What is reorg and runstats in db2?
What is commit in db2?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
What is db2 purescale?
What is dbrm library?