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

0 Answers   Satyam,

---

how to unload different table data into different gdg files/ vsam files.

3 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  

---

why we go for SPUFI for creating tables or for sql queries?

4 Answers  

---

How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

0 Answers  

---

What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

1 Answers  

---

how we will do null data selection in cobol-db2 program

2 Answers   Wipro,

---

is there any restrictions for unions ?

4 Answers   Patni,

---

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,

---

What are the uses of db2 optimizer?

0 Answers  

---

How Plan is created while executing the query using SPUFI?

3 Answers  

---