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

3 Answers
7536 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sqlca?

1065

What is a bind in db2?

1039

When the like statement is used?

1222

Name the various locking levels available?

1089

Explain about rct.

1085

What is the latest version of ibm db2?

1264

What is dbrm in db2 database?

1108

How to fetch the last row from the table in SQL (db2)?

1651

What is db2 connect?

1064

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2065

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8278

What is the clustering index in the db2 database?

1001

What is runstats and reorg in db2?

1296

What is a db2 package?

1049

What r the comman abends in db2, jcl and cobol???????

2250