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 do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,

---

What is the maximum size of varchar data type in db2?

0 Answers  

---

What is the advantage in De-normalizing tables in DB2?

0 Answers  

---

max number of columns in a db2 table?

6 Answers  

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers   MCN Solutions,

---

How to see the structure of db2 table??

4 Answers   IBM,

---

What is the role of the data page in the db2 database?

0 Answers  

---

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

---

What is cobol db2?

0 Answers  

---

What is the clustering index in the db2 database?

0 Answers  

---

How many buffer pools are there in DB2?

2 Answers  

---

what is + sign and -ve sign for sql code ?

1 Answers   TCS,

---