What do you need to do before you do EXPLAIN ?

1 Answers  

---

Explain package in db2 and its advantages?

0 Answers  

---

What is the use of runstats in db2?

0 Answers  

---

in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....

4 Answers   Infosys,

---

What is a correlated sub query?

2 Answers  

---

How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,

---

Can you define an Index if the table size less than 10 PAGES?

1 Answers   IBM,

---

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

1 Answers  

---

What happens in bind step in a db2 program?

0 Answers  

---

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,

---

In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  

---

What are the various locks available?

5 Answers   CTS,

---