Answer / pradeep

a clustered index is a indexin which both index and data
rows will be arranged in some particular sequence

datarows will be arranged based on the index in leaf pages

how can i pull up a query which was previously stored in qmf

3 Answers  

---

When is the skeleton cursor table created?

1 Answers  

---

Are view updateable?

0 Answers  

---

How do I add a column to an existing table in db2?

0 Answers  

---

what is consistency token

3 Answers  

---

---

What is scrollable cursor in db2?

0 Answers  

---

What does db2 plan contain?

0 Answers  

---

what happend with out using Commit,when closing cursor and program?

5 Answers   CSC,

---

Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,

---

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,

---

What is a DB2 bind?

1 Answers   Logica CMG,

---

can you use symbolic parameters in JOB?

5 Answers   IBM,

---