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,

---

When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  

---

What is syscat in db2?

0 Answers  

---

DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?

1 Answers   IBM,

---

How to create db2 table in mainframe?

0 Answers  

---

What are types of indexes?

0 Answers  

---

in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers   Infosys,

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

What does a deadlock mean in DB2?

0 Answers  

---

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,

---

How can record locking be achieved in those DB2 versions which do not support it?

0 Answers  

---

How is deadlock resolved?

0 Answers  

---