Answer / sai prakash

It is a default isolation level. It puts a lock on the data that has been fetched, so that the retrieved data can be updated or deleted.

Answer / siris

CURSOR STABILITY(CS):-
**it is row level locking...
**An Exclusive lick acquired on that row,the row to be
update....
**The lock is released on that row the control moves to the
next updatable row...

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  

---

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,

---

What is concurrency in db2?

1 Answers  

---

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  

---

how to resolve -811

2 Answers   IBM,

---

What will the COMMIT accomplish?

5 Answers  

---

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

0 Answers   IBM,

---

Give the COBOL definition of a VARCHAR field.

2 Answers  

---

My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers   Xansa,

---

What is lock escalation in db2?

0 Answers  

---

what happend with out using Commit,when closing cursor and program?

5 Answers   CSC,

---