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 STOSPACE Utility used for?
how to resolve -805. give clear explination for that
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is package in db2 mainframe?
wht steps we need will coding cobol and db2 pgm ?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
What's The Percentage Free Space ?
What is isolation level in db2?
What type of database is db2?
what needs to be done if a table is in copy pending / check pending status?
What are the various locks available?