I dont think records are stored in the sorted order of primary key in DB2.

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?

Question Posted / anju

Answer Posted / anju

I dont think records are stored in the sorted order of primary key in DB2. It happens only in VSAM!

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Differentiate between cs and rr isolation levels? Where do you specify them?

1074

What is null indicator in cobol db2?

1070

Define db2.

1120

B37 abend during spufi?

1463

What does db2 blu stand for?

1171

What are the benefits of using the db2 database?

1235

What is db2 command?

1044

What is explain in db2?

1036

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

1119

What is db2? Explain.

1052

What are the uses of db2 optimizer?

1299

What is bind and rebind in db2?

1141

What is the use of db2?

1060

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2951

What is the usage of open cursor command?

1104