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 |
Why might full image copies be faster to implement than an incremental image copy?
Can we able to find all the Table names under a Particular Plan?
How do you find the maximum value in a column in db2?
how to fetch first 100 rows in db2
How to update more then one record using update?
Can you access the DB2 Directory table using SQL?
What is an alias?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
What is referential integrity?
What is a DB2 catalog?
Explain the EXPLAIN statement?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?