How many clustering indexes can be defined for a table?

2 Answers  

---

Mention data types used in db2 ?

0 Answers  

---

What do you mean by NOT NULL WITH DEFAULT? When will you use it?

3 Answers  

---

How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,

---

Mention and explain the contention situations caused by locks?

1 Answers  

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---

What are data types?

2 Answers  

---

What is copy pending and check pending in db2?

0 Answers  

---

what is diffrence b/w file-aid tool and file-aid utility???

1 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,

---

What is the role of the data page in the db2 database?

0 Answers  

---

What is the max length of sqlca?

0 Answers  

---