If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

0 Answers  

---

What will the COMMIT accomplish?

5 Answers  

---

My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---

What db2 400?

0 Answers  

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers  

---

What are some SQL aggregates and other built-in functions?

2 Answers  

---

How to resolve -805 error in DB2?

1 Answers   Cap Gemini,

---

What is difference between alias and synonym in db2?

0 Answers  

---

On the create tablespace, what does the CLOSE parameter do?

1 Answers  

---

How can you classify the locks in db2?

0 Answers  

---