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

0 Answers  

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

Can a array declared with an index be displayed(readable format) in spool?

4 Answers   Syntel, UST,

---

What is the advantage in De-normalizing tables in DB2?

0 Answers  

---

Update command

1 Answers  

---

---

What can the Locate option of the Repair Utility accomplish?

2 Answers  

---

What is role in db2?

0 Answers  

---

Describe major components of db2?

0 Answers  

---

What is syscat in db2?

0 Answers  

---

Is db2 a database?

0 Answers  

---

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

1 Answers  

---

what is rebinding ?

1 Answers   IBM,

---