How many clustering indexes can be defined for a table?

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 are PACKAGES ?

3 Answers  

---

what is the use of cursors?

3 Answers   iGate,

---

What are the benefits of using the db2 database?

0 Answers  

---

---

how to resolve -811

2 Answers   IBM,

---

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,

---

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,

---

What are some SQL aggregates and other built-in functions?

2 Answers  

---

What do you need to do before you do EXPLAIN ?

1 Answers  

---

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,

---

define clustering index.

0 Answers  

---