What is the difference between CS and RR isolation levels?

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

---

can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,

---

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  

---

how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

10 Answers   IBM,

---

What is the use of commit in db2?

0 Answers  

---

On which levels locks can be applied?

0 Answers  

---

Which is faster delete or truncate?

0 Answers  

---

What does the sqlcode of -818 pertain to?

3 Answers  

---

What is an alias and how does it differ from a synonym?

3 Answers  

---

Explain db2.

0 Answers  

---

What is a DB2 catalog?

2 Answers  

---