How many Buffer pools are there in DB2 and what are they?

1 Answers   IBM,

---

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

---

how to resolve -811 error. give clear explination

4 Answers   IBM,

---

what is check point and restart Logic ? why do we go for that ??

2 Answers   CGI, UST, Xansa,

---

How many clustering indexes can be defined for a table?

2 Answers  

---

---

Could anyone clearly explain the diference between sub query and correlated sub query?

3 Answers  

---

What is the purpose of the QUIESE Utility?

1 Answers  

---

How will fetch last 5 rows from table in db2

6 Answers  

---

What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  

---

I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.

8 Answers  

---

Are view updateable?

0 Answers  

---

what are the bind parameters?

5 Answers   IBM,

---