Is db2 a mainframe database?

0 Answers  

---

What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,

---

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

---

How do you select a row using indexes in db2?

0 Answers  

---

what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,

---

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 soft code for deadlock ?

2 Answers   Logica CMG,

---

what is rebinding ?

1 Answers   IBM,

---

What is Reorg Recovery? when will you run it?

2 Answers  

---

Mention and explain the contention situations caused by locks?

1 Answers  

---

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  

---