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 the difference between static and dynamic SQL?

1 Answers  

---

How do you insert a record with a nullable column?

2 Answers  

---

What is copy pending and check pending in db2?

0 Answers  

---

what is dynamic cursor?gives syntax for this?

1 Answers   TCS,

---

What is a clustering index?

2 Answers  

---

What are the different types of base tables?

0 Answers  

---

How would the varchar column remarks defined?

0 Answers  

---

I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 Answers  

---

What does the RUNSTATS Utility do?

4 Answers  

---

What is UNION,UNION ALL?

2 Answers  

---

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,

---