Answer / ankitha

declare temp table with fields pkey and commit frequency.
then set commit frequency ie after 100 records it should
tabulate the temp table and in procerdure division read the
last pk value and should start updating after that pk value
and should delete this temp tble after the final commit or
stop run.

How does DB2 determine what lock-size to use?

2 Answers  

---

How do you eliminate duplicate values in db2?

0 Answers  

---

What is a predicate?

1 Answers  

---

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,

---

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

---

Plan has the optimized access path in it. But is that optimized access path is attained or known

1 Answers   IBM,

---

What is db2 isolation?

2 Answers  

---

what is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,

---

How would you print the output of an SQL statement from SPUFI?

2 Answers  

---

What is the purpose of using commit?

0 Answers  

---

What keyword does an SQL SELECT statement use for a string search?

2 Answers  

---

What is a correlated sub query?

2 Answers  

---