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 |
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
What is precompiler in db2?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
how to resolve -805. give clear explination for that
Is db2 free?
what is copy pending and check pending ?
How do I copy a table in db2?
What is an instance database?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
Why do chiropractors use drop table?
Where do you specify them?
Explain package in db2 and its advantages?