what is difference between random and sequence file access

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dbrm library?

789


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1967


What is performance tuning db2?

834


What are the prerogatives?

801


How do I connect my db2 database to ibm?

792


How do I add a column to a table in db2?

838


What is dbrm? When it will be created?

773


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1848


Explain packages.

865


How do you eliminate duplicate values in db2?

897


Can you tell me how can you find out the # of rows updated after an update statement?

860


Why do we bind in db2?

879


What is db2 bind process?

934


Who uses db2?

763


What is a trigger in the db2 database?

801