How does one remove entries from the SCT02 table?

1 Answers  

---

What is the usage of open cursor command?

0 Answers  

---

Explain how can you do the explain of a dynamic sql statement?

0 Answers  

---

When Can you be sure that a query will return only one row?

4 Answers   IBM,

---

What is dclgen (declaration generator)?

0 Answers  

---

what is rebinding ?

1 Answers   IBM,

---

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 deadlock?

2 Answers  

---

List down the types of triggers in the db2 database?

0 Answers  

---

Define check constraint.

0 Answers  

---

what is a trigger and types of triggers

3 Answers   HSBC,

---

Explain what a plan is?

3 Answers   CTS,

---