Explain package in db2 and its advantages?

0 Answers  

---

What are the prerogatives?

0 Answers  

---

Mention the location where the output received from explain statement is stored.

0 Answers  

---

Is it possible to precompile if db2 goes down?

4 Answers   Target,

---

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

---

---

what is static sql? what is dynamic sql? Give me details

3 Answers  

---

What is the physical storage length of timestamp data type?

0 Answers  

---

How to find schema of a table in db2?

0 Answers  

---

Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,

---

What is the logical entity between plan and Package?

5 Answers  

---

How many databases can be created inside an instance in db2 ?

0 Answers   MCN Solutions,

---

when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic

2 Answers   TCS,

---