Which one allows duplicate values Union or Union All ?

3 Answers  

---

What is the meaning concurrency in the db2 database?

0 Answers  

---

My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  

---

Mention the different locking levels that are available in db2.

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,

---

What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  

---

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,

---

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

0 Answers   IBM,

---

If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 Answers  

---

How do I delete a table in database?

0 Answers  

---

How do I start db2 in windows?

0 Answers  

---