How to fetch the uncommited data from table ?

1 Answers   JPMorgan Chase,

---

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 happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 Answers  

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,

---

What is a db2 cursor?

0 Answers  

---

What is the difference between nvl and coalesce?

0 Answers  

---

What does sqlcabc has?

0 Answers  

---

what are the SQL codes u freequently got?

2 Answers   Logica CMG,

---

what is sql abend code -801,-802?

2 Answers  

---

What is the picture clause of null indicator variable?

0 Answers  

---

quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  

---