what is cursor stability?
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 4 Yes | 0 No |
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...
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the use of db2?
What is page size in db2?
Why do we use cursor?
What is the difference between Where and Having Clause
What is a trigger in the db2 database?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
What are the four lockable units for DB2?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
What is innodb buffer pool?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?