I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

how to identify the pseudo conversation by seeing the program

2 Answers   DELL,

---

What is the use of predicate?

0 Answers  

---

What is alias in db2?

0 Answers  

---

What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,

---

---

In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,

---

Name the lockable units in DB2?

0 Answers  

---

What is the use of db2?

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's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,

---

Which catalog tables contain authorization information?

1 Answers  

---

what is difference between Plan and Package

1 Answers   Syntel,

---