Answer Posted / valmiki1980

1. put autocomit No in spufi and run insert command
2. run the insert command thru cob-db2 program.
this results -911 error

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

587

---

What is temporal table in db2?

603

---

What is meant by union and union all?

589

---

What is the difference between nvl and coalesce?

602

---

what is utility for parm lib

1882

---

---

What does runstats do in db2?

607

---

Explain correlated sub-queries.

589

---

What are the contents of a dclmgen?

628

---

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

579

---

How is a typical db2 batch pgm executed?

642

---

Differentiate between cs and rr isolation levels? Where do you specify them?

587

---

What is the physical storage length of time data type?

673

---

How to view db2 table structure?

593

---

What is a storage group (stogroup)?

778

---

What are union and union all?

541

---