What is EXPLAIN?

1 Answers  

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

my project is insurance management system,how to explain my work environment in interview?

2 Answers   CGI, Value Labs,

---

What is a trigger in the db2 database?

0 Answers  

---

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 does db2 blu stand for?

0 Answers  

---

What parameters are used to control the free space in DB2?

0 Answers  

---

What is a dbrm in db2?

0 Answers  

---

How to execute stored procedures?

0 Answers  

---

How are write I/Os from the buffer pool executed?

1 Answers  

---

Name some fields from SQLCA.

2 Answers  

---

What is the maximum length of sqlca?

0 Answers  

---