What is the use of dclgen in db2?

0 Answers  

---

how do you resolve -805?

3 Answers   HCL,

---

Explain about open switch business continuity software?

0 Answers  

---

How to find the maximum value in a column in the db2 database?

0 Answers  

---

What is a buffer pool?

2 Answers  

---

---

Which isolation level provides highest data integrity?

0 Answers  

---

how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?

1 Answers   Hewitt,

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

0 Answers   IBM,

---

Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,

---

Explain package in db2 and its advantages?

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  

---

What is the difference between nvl and coalesce?

0 Answers  

---