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.

What Utility is used to migrate DB2 from one release to the next?

1 Answers  

---

What is cursor stability in db2?

0 Answers  

---

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

---

What is the significance of DB2 free space and what parameters control it?

1 Answers  

---

Where do you specify them?

0 Answers  

---

---

what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

---

When Can you be sure that a query will return only one row?

4 Answers   IBM,

---

Which isolation level provides maximum concurrency?

0 Answers  

---

can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,

---

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)

2 Answers  

---

Explain what are the various isolation levels possible?

0 Answers  

---