What is the clustering index in the db2 database?

0 Answers  

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  

---

What are some SQL aggregates and other built-in functions?

2 Answers  

---

What is dynamic SQL?

1 Answers   ADP,

---

When the like statement is used?

0 Answers  

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---

How do I add a column in db2?

0 Answers  

---

What is a collection?

3 Answers  

---

What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

1 Answers  

---

how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,

---

What is the physical storage length of the data types date, time, and timestamp?

0 Answers  

---