How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.

7 Answers   TCS,

---

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,

---

Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers  

---

Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 Answers  

---

How to execute stored procedures?

0 Answers  

---

---

Explain transactions, commits and rollbacks in DB2.

3 Answers  

---

What is the maximum size of a char data type in db2?

0 Answers  

---

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  

---

What are the functions of Bind?

2 Answers   Amdocs, IBM,

---

What is correlated subquery?

1 Answers  

---

What do you need to do before you do EXPLAIN ?

1 Answers  

---