How can you display the current date & current time ?

7 Answers   Cap Gemini,

---

What is a cursor?

2 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 pagespace?

1 Answers  

---

How does DB2 store NULL physically?

2 Answers  

---

---

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  

---

What is db2 catalog database?

0 Answers  

---

How can you classify the locks in db2?

0 Answers  

---

WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,

---

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---

What is REORG? When is it used?

4 Answers  

---

How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

2 Answers   IBM, Infosys,

---