Why do we bind in db2?

0 Answers  

---

i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

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  

---

what is load and unload in db2

1 Answers   IBM,

---

What is the FREE command?

1 Answers  

---

How will you delete duplicate records from a table?

7 Answers   Google,

---

How do we specify index to include or not during bind process.

0 Answers   Satyam,

---

what is the Foreign key? explain?

2 Answers  

---

What is declare cursor?

0 Answers  

---

How to find primary key of a table in db2?

0 Answers  

---

What is correlated subquery?

1 Answers  

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---