What is host variable?

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 do I import data from excel to db2?

0 Answers  

---

When the like statement is used?

0 Answers  

---

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,

---

---

My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,

---

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  

---

What db2 400?

0 Answers  

---

What is the meaning concurrency in the db2 database?

0 Answers  

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---

What is auditing?

2 Answers  

---

What is copy book?

1 Answers   Thomson Reuters,

---