What is a db2 package?

0 Answers  

---

what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

2 Answers  

---

I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 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  

---

Is ibm db2 free?

0 Answers  

---

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

2 Answers  

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  

---

What is package versioning? Please give an example.

1 Answers  

---

What is the self-referencing constraint?

2 Answers  

---

what is utility for parm lib

0 Answers   IBM,

---

What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,

---

if i made sme changes in sub pgm wht r the things to be done for this ?

1 Answers   TCS,

---