Explain about cursor stability?



Explain about cursor stability?..

Answer / Bhupendra

Cursor stability in DB2 refers to the consistency of data viewable by a cursor. There are three levels of cursor stability: dynamic, static, and scroll-sensitive dynamic. Dynamic shows all updated or deleted rows since the first fetch, while static only shows unchanged rows. Scroll-sensitive dynamic allows updating, inserting, and deleting data while scrolling through the result set.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is role in db2?

1 Answers  


What is db2 purescale?

1 Answers  


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

0 Answers  


What is runstats and reorg in db2?

1 Answers  


How to run db2 command in windows?

1 Answers  


List down the data types in the db2 database.

1 Answers  


On which levels locks can be applied?

1 Answers  


When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  


How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,


can we view the access paths created by dbrm ? how ? thx

3 Answers   IBM,


Explain about rct.

1 Answers  


How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers  


Categories