What is the use of dclgen in 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 is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  

---

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  

---

Explain about mirror activator disk mirroring?

0 Answers  

---

What are the 2 sqlcodes that are returned?

0 Answers  

---

what is dynamic cursor?gives syntax for this?

1 Answers   TCS,

---

What is the self-referencing constraint?

2 Answers  

---

how to check the table is empty or not?

3 Answers   IBM,

---

How to find last record before record through SQLRPGLE?

1 Answers   IBM,

---

What are the various data types available in db2?

0 Answers  

---

What language is db2 written in?

0 Answers  

---