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 total syntax for fetch ? can any one please give me all the details of fetch ? thx
What is a SELECT statement?
What is db2 isolation?
What if we fail to give values in columns declared as NOT NULL ?
What happens to the PLAN if index used by it is dropped?
Can one database have multiple instances?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
What does the RUNSTATS Utility do?
What is sqlca?
How to take backup of table in db2?
How can we read records for specific member in CL? AND rpg?
How to retrieve rows from a db2 table in embedded sql?