What is a composite index and how does it differ from a multiple index?

1 Answers  

---

How are write I/Os from the buffer pool executed?

1 Answers  

---

What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  

---

What is DCLGEN?

2 Answers  

---

What is phantom read in db2?

0 Answers  

---

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,

---

how can u nderstand the sql stmts executed successfully or not ?

1 Answers   TCS,

---

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 db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 Answers  

---

What is deadlock in db2?

0 Answers  

---

How can you display the current date & current time ?

7 Answers   Cap Gemini,

---

Where do you specify them?

0 Answers  

---