I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  

---

Explain about rct.

0 Answers  

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---

What is a buffer pool?

2 Answers  

---

How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,

---

DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?

1 Answers   IBM,

---

When is the skeleton cursor table created?

1 Answers  

---

What is db2 isolation?

2 Answers  

---

Is db2 a mainframe database?

0 Answers  

---

How do I import data from excel to db2?

0 Answers  

---

What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  

---

What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  

---