Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

1 Answers  

---

In a DB2-CICS program which is acts as co-ordinator and which is participant?

1 Answers   IBM,

---

if i made sme changes in sub pgm wht r the things to be done for this ?

1 Answers   TCS,

---

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,

---

What is DCLGEN?

2 Answers  

---

---

How is deadlock resolved?

0 Answers  

---

Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 Answers  

---

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

---

how can i pull up a query which was previously stored in qmf

3 Answers  

---

When is the access path determined for dynamic SQL?

2 Answers  

---

How to solve S0C7 abend with out using DISPlay in 10 mins?

1 Answers   IBM,

---