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 is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,

---

What is the purpose of rollback and commit?

0 Answers  

---

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,

---

What is cloudant database?

0 Answers  

---

What types of tables are there in the db2 database?

0 Answers  

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---

What is buffer pool in the db2 database?

0 Answers  

---

How to solved 818 error

4 Answers   Keane India Ltd, Wipro,

---

What does the RUNSTATS Utility do?

4 Answers  

---

In terms of DB2 indexing, what is the root page?

1 Answers  

---

What do you do to keep the cursor from closing after a commit?

1 Answers  

---