5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,

---

How to view db2 table structure?

0 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,

---

Explain the contention situations caused by locks?

0 Answers  

---

What is an instance in db2?

0 Answers  

---

what is a trigger and types of triggers

3 Answers   HSBC,

---

How to find the maximum value in a column in the db2 database?

0 Answers  

---

Could anyone clearly explain the diference between sub query and correlated sub query?

3 Answers  

---

What is the result of open cursor statement?

0 Answers  

---

what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

---

What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 Answers  

---