what is cursor stability?

Answers were Sorted based on User's Feedback



what is cursor stability?..

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

what is cursor stability?..

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

Post New Answer

More DB2 Interview Questions

What is the STOSPACE Utility used for?

1 Answers  


how to resolve -805. give clear explination for that

2 Answers   IBM,


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 ?

0 Answers   JPMorgan Chase,


What is package in db2 mainframe?

0 Answers  


wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,






Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

0 Answers  


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

2 Answers   Logica CMG,


What's The Percentage Free Space ?

0 Answers   IBM,


What is isolation level in db2?

0 Answers  


What type of database is db2?

0 Answers  


what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,


What are the various locks available?

5 Answers   CTS,


Categories