how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,

---

Which one allows duplicate values Union or Union All ?

3 Answers  

---

What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  

---

What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  

---

What are some characteristics of columns that benefit from indexes?

1 Answers  

---

---

What is dynamic SQL?

1 Answers   ADP,

---

In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  

---

What is cursor with hold option in db2?

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 is an asychronous write?

1 Answers  

---

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

---

Which catalog tables contain authorization information?

1 Answers  

---