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 |
can we view the access paths created by dbrm ? how ? thx
Why cursor is used in db2?
How to access db2 tables in mainframe?
What is the usage of open cursor command?
How is deadlock resolved?
what is difference between Static call and Dynamic call? How does it function?
What is the logical entity between plan and Package?
What are the rules for db2 programming?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
Name some fields from SQLCA.
Is it possible to precompile if db2 goes down?
what is a corelated subquerry?