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 |
What is role in db2?
What is db2 purescale?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is runstats and reorg in db2?
How to run db2 command in windows?
List down the data types in the db2 database.
On which levels locks can be applied?
When is the authorization check on DB2 objects done - at BIND time or run time?
How to know the primary key of a table without defining the primary key in the table?
can we view the access paths created by dbrm ? how ? thx
Explain about rct.
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?