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 total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers   IBM,


What is a SELECT statement?

1 Answers  


What is db2 isolation?

2 Answers  


What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,


What happens to the PLAN if index used by it is dropped?

1 Answers  


Can one database have multiple instances?

1 Answers  


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

1 Answers   Infosys,


What does the RUNSTATS Utility do?

4 Answers  


What is sqlca?

1 Answers  


How to take backup of table in db2?

1 Answers  


How can we read records for specific member in CL? AND rpg?

1 Answers  


How to retrieve rows from a db2 table in embedded sql?

1 Answers  


Categories