Answer Posted / karthikeyan

Commit:After end of the every permanent Transaction we used
commit.This is most probably used used for record tracking
purpose in the issue log.

Rollback:If any error occur during ur transaction (ex: any
data error) ur procedure will autoimatically call the
rollback procedure and it rollback all the stored record
from the table.u want to use the save point concept while
using the rollback.

What is a db2 package?

1119

---

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2290

---

can all users have the privilage to use the sql statement select * (dml)?

1219

---

B37 abend during spufi?

1504

---

How can deadlocks be resolved?

986

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2381

---

What is db2?

1229

---

Mention the definition of cobol in varchar field.

1314

---

What is a db2 collection?

1105

---

Can there be more than one cursor open for any program?

1223

---

What's The Error Code For Unique Index Voilation?

1296

---

What is runstats and reorg in db2?

1355

---

What is db2 stogroup?

1220

---

What is db2 connect?

1123

---

List down the types of triggers in the db2 database?

1078

---