what is difference between random and sequence file access

Question Posted / guest

1 Answers
5133 Views
Syntel, I also Faced
E-Mail Answers

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

What is read-only cursor?

1 Answers

Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.

1 Answers

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers Amdocs,

Which transaction use a command thread ?

1 Answers

wht steps we need will coding cobol and db2 pgm ?

6 Answers CGI,

How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 Answers

What is a data page?

1 Answers

Which command is used to remove all rows from a table?

0 Answers

what is main use of table space and index object? please its urgent