what is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,

---

how to check the table is empty or not?

3 Answers   IBM,

---

When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,

---

Explain correlated sub-queries.

0 Answers  

---

Where do you specify them?

0 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 statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers  

---

what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,

---

Name some fields from SQLCA.

2 Answers  

---

What are the three lock types?

2 Answers  

---

How do I change the column size in db2?

0 Answers  

---

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,

---