i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  

---

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,

---

What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

1 Answers  

---

What is release/acquire in bind?

0 Answers  

---

What is a db2 schema?

0 Answers  

---

i want to delete 20th million record how ?

4 Answers   IBM,

---

What is rct?

0 Answers  

---

db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2

9 Answers   TCS,

---

How can you do the explain of a dynamic sql statement?

0 Answers  

---

If I have a view which is a join of two or more tables, can this view be updateable?

0 Answers  

---

What is a thread?

3 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2 Answers  

---