what is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,

---

How to create a table using embedded sql?

1 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  

---

Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,

---

When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 Answers  

---

List down the data types in the db2 database.

0 Answers  

---

How can you compare table column after update and before update?

5 Answers   Satyam,

---

What is CHECK PENDING ?

5 Answers  

---

What is image copy?

1 Answers   Virtusa,

---

How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  

---

What is meant by explain?

0 Answers  

---

explain about index with examples

2 Answers   Syntel,

---