What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 Answers  

---

How many sub queries can you combine together ?

4 Answers   IBM,

---

the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

2 Answers   Logica CMG,

---

What is a composite index and how does it differ from a multiple index?

1 Answers  

---

What is buffer pool in the db2 database?

0 Answers  

---

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

0 Answers   Broadridge,

---

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

0 Answers  

---

How do you insert a record with a nullable column?

2 Answers  

---

What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,

---

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

---

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 Answers  

---

What is DB2 (IBM Database 2)?

3 Answers  

---