What is the difference between plan and package in db2?

0 Answers  

---

Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

2 Answers  

---

what is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,

---

What is cascading rollback?

0 Answers  

---

How is a typical DB2 batch program executed ?

1 Answers  

---

How to resolve deadlock issue

5 Answers   IBM,

---

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,

---

what is a collection?

2 Answers  

---

What are db2 tables?

0 Answers  

---

Return code 100 means?

6 Answers   Cap Gemini,

---

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---

what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names

5 Answers   Accenture,

---