What are the full forms of spufi and dclgen and why are they used?

0 Answers  

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

What is REORG? When is it used?

4 Answers  

---

what is the difference between where clause and having clause

2 Answers   IBM,

---

What is the syntax required for the creation of a cursor?

1 Answers  

---

What is buffrpool? Where we use it ?

2 Answers   Tesco,

---

What is Call attach facility? How does it work?

1 Answers   Syntel,

---

What is concurrency in db2?

1 Answers  

---

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,

---

What type of database is db2?

0 Answers  

---

Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  

---

What are the functions of Bind?

2 Answers   Amdocs, IBM,

---