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

where can we use index and subscript ? with example ?

3 Answers   CTS,


What do you mean by storage group (stogroup)?

0 Answers  


What is an inner join, and an outer join ?

1 Answers   CTA,


Which component is responsible for db2 startup and shutdown?

0 Answers  


What does db2 blu stand for?

0 Answers  






I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,


Write a query to retrive partial string.

2 Answers  


Where do you specify them?

0 Answers  


What is a correlated sub query?

2 Answers  


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

0 Answers  


Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  


What is deadlock in db2?

0 Answers  


Categories