What is the difference between plan and package in db2?

0 Answers  

---

What is the difference between bind and rebind in db2?

0 Answers  

---

What is db2 bind?

0 Answers  

---

Which component is used to execute the sql statements?

0 Answers  

---

What are db2 objects?

0 Answers  

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

---

pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,

---

is there any restrictions for unions ?

4 Answers   Patni,

---

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 Answers  

---

cursor with hold explain ?

1 Answers   Verizon,

---

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,

---

List out the three types of page locks that can be held.

0 Answers  

---