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  

---

what is a corelated subquerry?

0 Answers   IBM,

---

What is an alias and how does it differ from a synonym?

3 Answers  

---

What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  

---

Mention the location where the output received from explain statement is stored.

0 Answers  

---

---

Can you Average the Characters ?

3 Answers  

---

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers   Broadridge,

---

I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

1 Answers   Cap Gemini,

---

What is the role of schema in the db2 database?

0 Answers  

---

Explain an outer join?

1 Answers  

---

why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 Answers  

---

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

---