Answer Posted / mohammadanis

DB2 Isolation is locking technqiue for tables.It can given
while binding the programs. There are several Isolation
levels are there,

1 CS(cursor stability)
2 RR(repeatable read)
3 RS(READ Stability)
4 UR(Uncommited read also known as Dirty read

Why do we need reorg in db2?

933

---

Which command is used to connect to a database in DB2 ? Give the Syntax.

1048

---

What is image copy in db2?

958

---

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1129

---

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1024

---

Can we update view in db2?

954

---

What is multi row fetch in db2?

1001

---

Discuss about db2 bind?

1056

---

What is a collection in db2?

998

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9048

---

Where can you declare a cursor in a cobol-db2 program?

1023

---

How do I add a column in db2?

1011

---

How to retrieve rows from a db2 table in embedded sql?

1350

---

Explain the contents that are a part of dclgen.

1047

---

What is the physical storage length of timestamp data type?

1035

---