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...

What are the prerogatives?

0 Answers  

---

Where would you find information about the type of database authority held by the user?

2 Answers  

---

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  

---

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

0 Answers  

---

How do I delete a table in database?

0 Answers  

---

What are the rules for db2 programming?

0 Answers  

---

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  

---

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

0 Answers  

---

what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,

---

how can we retrieve the 100 records of the file ?

2 Answers   IBM,

---