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,

---

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  

---

Is there any advantage to denormalizing DB2 tables?

1 Answers  

---

Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  

---

what is the sqlcode -501

5 Answers   IBM, Polaris, Zeus,

---

---

In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,

---

Describe major components of db2?

0 Answers  

---

What are the bind parameters ibm db2?

0 Answers  

---

How are write I/Os from the buffer pool executed?

1 Answers  

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

What is difference between alias and synonym in db2?

0 Answers  

---

What is the information associated with sysibm.syslinks table?

0 Answers  

---