Answer Posted / girish kumar

suppose if we have 1000 rows for update, while we updating
incase if we get abend occures at 999 even a single record
could not be saved to database with out execute commit.
so that if we can place a commit for every 100 records
incase abend occres at 999 cursor start for 900 onwords by
issuing rollback along with commit.


this is db2 logic better to refer MUTTU REFRESHNER

Give a brief description of db2 isolation levels?

1046

---

How will you return the number of records in table?

915

---

What is the maximum size of a char data type in db2?

993

---

What is page size in db2?

958

---

How to view db2 table structure?

1000

---

What is precompiler in db2?

995

---

How do I add a column to an existing table in db2?

1010

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2369

---

Mention the downsides of page level lock.

1145

---

What is blu acceleration in db2?

1047

---

How do I create a view in db2?

1004

---

What is copy pending status in db2?

1101

---

What is check constraint in db2?

1062

---

is it compulsory commitment control in journal?

2458

---

Highlight all the advantages that are attached to a package.

1100

---