Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

---

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

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

3 Answers  

---

What are catalog tables in db2?

0 Answers  

---

wht r the requirements for writing a cobol-db2 pgm ?

4 Answers   IBM,

---

what are the SQL codes u freequently got?

2 Answers   Logica CMG,

---

What is the use of reorg in db2?

0 Answers  

---

How to find last record before record through SQLRPGLE?

1 Answers   IBM,

---

What is the clustering index in the db2 database?

0 Answers  

---

What are concurrency issues?

0 Answers  

---

How is a typical DB2 batch program executed ?

1 Answers  

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---