What is the difference between CS and RR isolation levels?

1 Answers  

---

What is RUNSTATS?

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  

---

Can SQL statements/queries be included in a copybook?

2 Answers  

---

What is the role of data manager in the db2 database?

0 Answers  

---

What is cascading rollback?

0 Answers  

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

0 Answers  

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---

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

4 Answers   IBM,

---

What is the cobol picture clause of the db2 data types date, time, timestamp?

0 Answers  

---

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

---

What is phantom read in db2?

0 Answers  

---