In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

---

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,

---

DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?

1 Answers   IBM,

---

What is IMAGECOPY ?

6 Answers  

---

What is check constraint. Explain with example.

0 Answers  

---

What are the benefits of using the db2 database?

0 Answers  

---

how to resolve -811 error. give clear explination

4 Answers   IBM,

---

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,

---

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

1 Answers   Accenture,

---

One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?

3 Answers  

---

How would one remove old reorg information from the DB2 catalog?

2 Answers  

---

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

0 Answers  

---