How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  

---

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

9 Answers   Cap Gemini,

---

What are the two types of logging in the db2 database? Explain them.

0 Answers  

---

How does a cursor work?

0 Answers  

---

wht is d/f between union and joins ?

2 Answers  

---

how to get duplicate records from tables?write qurey for this?

4 Answers   ANZ,

---

Describe major components of db2?

0 Answers  

---

What is the difference between bind and rebind in db2?

0 Answers  

---

What is collection in db2 bind?

0 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  

---

Explain transactions, commits and rollbacks in DB2.

3 Answers  

---

What is the use of predicate?

0 Answers  

---