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  

---

How do you pull up a query which was previously saved in qmf?

0 Answers  

---

What is bind in db2?

0 Answers  

---

What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  

---

What is an alias and how does it differ from a synonym?

3 Answers  

---

What happens in bind step in a db2 program?

0 Answers  

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  

---

My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers   Xansa,

---

how can we retrieve the 100 records of the file ?

2 Answers   IBM,

---

What information is contained in a SYSCOPY entry?

2 Answers  

---

How do you prepare a COBOL + DB2 program from coading till execution ?

1 Answers   Amdocs, Xansa,

---