In terms of DB2 indexing, what is the root page?

1 Answers  

---

B37 abend during spufi?

0 Answers   IBM,

---

What is Declaration Generator(DCLGEN)?

1 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  

---

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 Static and dynamic linking

1 Answers   Virtusa,

---

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  

---

What is schema in db2?

0 Answers  

---

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

---

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

2 Answers  

---

what is the input to PLAN? what is the input to DBRM?

4 Answers  

---

How does a cursor work?

0 Answers  

---