How do you select a row using indexes in db2?

0 Answers  

---

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

1 Answers   IBM,

---

Mention and explain the contention situations caused by locks?

1 Answers  

---

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,

---

what is the use of cursors?

3 Answers   iGate,

---

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

1 Answers  

---

What is explain in db2?

0 Answers  

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

---

what is difference between Plan and Package

1 Answers   Syntel,

---

What is correlated subquery?

1 Answers  

---

What are the disadvantages of using VARCHAR?

3 Answers  

---

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

---