Answer Posted / sachin

-100 when the rows found.
-805 plan not found
-305 null indicator not declared
-104 invalid keyword
-199 illegal use of keyword
-206 table not foung
-310 for decimal column using non decimal
-407 try to insert the null value in the not null column
-501 try to close the curosr which are already open
-811 multirow select
-504 cursor not decalred
-818 time stamp mismatch
-180 date error
-181 date and time are invalid
-414 in the union the column are not same
-911
-913 both are for the deadlock
-904 for the resource not avable
-922 authorization failure
-924 coneection is not availbke

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

1106

---

What is access path in db2?

943

---

Why cursor is used in db2?

1003

---

What is host variable?

1027

---

what is the responsibility of the construction superintendent

2099

---

What is runstats db2?

977

---

If I have a view which is a join of two or more tables, can this view be updateable?

1100

---

What is bufferpool in db2?

1006

---

What is ibm db2 connect?

952

---

Explain in brief how does db2 determine what lock-size to use?

987

---

Explain the function of data manager.

1009

---

Is ibm db2 free?

972

---

How to find the maximum value in a column in the db2 database?

1040

---

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8181

---

How to check table size in db2 sap?

992

---