what is difference between random and sequence file access



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

Post New Answer

More DB2 Interview Questions

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?

3 Answers  


What is the default page size of buffer pools?

0 Answers  


Which isolation level provides maximum concurrency?

0 Answers  


What is cloudant database?

0 Answers  


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

8 Answers   CGI, Wipro,


What does an outer join do?

1 Answers   CTS,


What is reorg and runstats in db2?

0 Answers  


What is commit in db2?

0 Answers  


How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers   CTS, IBM,


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.

9 Answers   Cap Gemini,


What is db2 purescale?

0 Answers  


What is dbrm library?

0 Answers  


Categories