I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

---

Is the primary key a clustered index?

0 Answers  

---

Can we update view in db2?

0 Answers  

---

How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,

---

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 the connection string to connect to the DB2 Database ?

0 Answers   MCN Solutions,

---

what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,

---

how can you access index

4 Answers   IBM, Tech Mahindra,

---

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---

what is utility for parm lib

0 Answers   IBM,

---

What is db2 purescale?

0 Answers  

---

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

0 Answers   Mphasis,

---