db2 restart logic ?

1 Answers   DELL, HTC, UHG,

---

Explain an outer join?

1 Answers  

---

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

9 Answers   Cap Gemini,

---

is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,

---

How can you split a table in to exactly half?

7 Answers   HSBC,

---

---

What is the difference between CS and RR isolation levels?

1 Answers  

---

What is db2 and what is the use of db2 optimizer?

0 Answers  

---

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---

What is the difference between db2 and oracle?

0 Answers  

---

what is the name of the default db2 catalog database?

3 Answers   IBM,

---

What are the three DB2 date and time data types and their associated functions?

1 Answers  

---

Explain the contention situations caused by locks?

0 Answers  

---