Answer Posted / ranjana

its s9(9)v99.

What is db2 look?

972

---

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

2181

---

List out the three types of page locks that can be held.

1094

---

what is the sqlcode -501

12926

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1006

---

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1312

---

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1027

---

What is null indicator in db2?

1054

---

what is a corelated subquerry?

1066

---

What is the physical storage length of time data type?

1067

---

What is a db2 cursor?

1009

---

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1183

---

What are the benefits of using the db2 database?

1157

---

What is the function of logging in the db2 database?

1071

---

i want to maintain uniqueness on pdf without make lf??????????

2100

---