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 DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

What is a cursor in programming?

0 Answers  

---

What is temporal table in db2?

0 Answers  

---

What is innodb buffer pool?

0 Answers  

---

What are packages in db2?

0 Answers  

---

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

0 Answers  

---

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

---

when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations

3 Answers   IBM,

---

What are the functions of Bind?

2 Answers   Amdocs, IBM,

---

How do you retrieve the data from a nullable column?

2 Answers  

---