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 technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

---

What do you mean by between and in? Is between inclusive of specified range values?

0 Answers  

---

How does DB2 use multiple table indexes?

1 Answers  

---

what is commit & rollback? When and where is used while compiling a cobol-db2 program?

2 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers  

---

how to fetch first 100 rows in db2

2 Answers   IBM,

---

Can SQL statements/queries be included in a copybook?

2 Answers  

---

What is the function of buffer manager?

1 Answers  

---

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 Answers  

---

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

---

What is a LIKE table and how is it created?

2 Answers  

---