Why select is not preferred in embedded sql programs?

0 Answers  

---

What are packages in db2?

0 Answers  

---

What is a db2 tablespace?

0 Answers  

---

define clustering index.

0 Answers  

---

On the create tablespace, what does the CLOSE parameter do?

1 Answers  

---

What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,

---

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,

---

why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 Answers  

---

What will the FREE command do to a plan?

2 Answers  

---

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  

---

What happens to a cursor after a commit?

3 Answers  

---

What is an alias?

3 Answers  

---