What is catalog database in db2?

0 Answers  

---

What is CHECK PENDING ?

5 Answers  

---

What is deadlock?

2 Answers  

---

What is query_cache_limit?

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,

---

What do you mean by NOT NULL? When will you use it?

3 Answers  

---

How to resolve -502 sql code in DB2?

2 Answers   Cap Gemini,

---

Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,

---

what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,

---

How to update more then one record using update?

5 Answers   IBM,

---

Explain the contention situations caused by locks?

0 Answers  

---

How would you find out the total number of rows in a db2 table?

0 Answers  

---