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

List out the buffer pools in db2

1055

What is the clustering index in the db2 database?

984

How many databases can be created inside an instance in db2 ?

1011

How do I copy a table in db2?

988

What is the syntax for seeing the columns and data types of a table in the db2 database?

1145

Give a brief description of db2 isolation levels?

1046

What is the difference between plan and package in db2?

1092

How to check sequence on a table in db2?

1043

What action db2 takes when a program aborts in the middle of a transaction?

1132

Define data page.

1048

What is the maximum size of varchar data type in db2?

1114

What is db2 optimizer?

1214

What is the role of the data page in the db2 database?

1009

What is concurrency?

1203

How do I import data from excel to db2?

1052