Why db2 is called db2?

0 Answers  

---

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  

---

What is the difference between static and dynamic SQL?

1 Answers  

---

How to compare data between two tables in db2?

0 Answers  

---

What is the usage of open cursor command?

0 Answers  

---

Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 Answers  

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

How do you retrieve the data from a nullable column?

2 Answers  

---

What is reorg in database?

1 Answers  

---

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2 Answers  

---

Explain correlated sub-queries.

0 Answers  

---