What is cursor stability in db2?

0 Answers  

---

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

0 Answers  

---

Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,

---

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  

---

1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 Answers  

---

---

what is the maximum number of tables that can be joined ?

8 Answers   IBM, TCS,

---

what is db2 restart?

0 Answers  

---

What is dpf in db2?

0 Answers  

---

On which levels locks can be applied?

0 Answers  

---

What is isolation level in db2?

0 Answers  

---

If I have a view which is a join of two or more tables, can this view be updateable?

0 Answers  

---

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,

---