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 a cursor and what is its function?

2 Answers  

---

What else is there in the PLAN apart from the access path?

1 Answers  

---

How can record locking be achieved in those DB2 versions which do not support it?

0 Answers  

---

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,

---

What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,

---

Comment whether the cursor is closed during commit or not.

0 Answers  

---

What is a predicate?

1 Answers  

---

What DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  

---

What is temporal table in db2?

0 Answers  

---

What are the bind parameters ibm db2?

0 Answers  

---

When Can you be sure that a query will return only one row?

4 Answers   IBM,

---