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.

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

9 Answers   Cap Gemini,

---

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  

---

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

10 Answers   IBM,

---

Explain the EXPLAIN statement?

1 Answers  

---

---

how can u retrieve the data from null values using applicaion program.

3 Answers   TCS,

---

how we will do null data selection in cobol-db2 program

2 Answers   Wipro,

---

what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?

3 Answers   Cap Gemini, Tech Mahindra,

---

What is difference between isnull and coalesce?

0 Answers  

---

Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

1 Answers  

---

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

5 Answers   Emsang,

---

What is isolation level?

4 Answers  

---