In this post, you will know advanced Cursor concepts in DB2. We know that CURSORS is a DB2 object. I have shared in my previous on DB2 cursors how to use in your program. In this post, you will learn the top keywords used in advanced cursors.
Top Key words in Advanced Cursors
- SENSITIVE- Latest updated data we can access
- INSENSITIVE- We cannot access latest updated data
- STATIC- Latest changes cannot be visible
- DYNAMIC-Latest changes are visible
- SCROLL ABLE CURSOR – Normal CURSOR. we can FETCH in forward direction. In SCROLLABLE, we can access rows, in forward and backward direction.
- WITH ROWSET POSITIONING – We can fetch multiple rows into COBOL host variable array. The maximum limit is ‘32767’ rows.
Top DB2 book must read and useful for all developers.
Useful DB2 Book
Recent Posts
- How to Call ‘DB2’ from Python
- Python ‘pdb’ Tutorial to Debug at Command Line
- Work from home Conference Calls these 5 Items you need for Super Voice Quality
- DB2: User-defined Function Syntax to Create, Drop
- AWS Encryption Top Supported Features
One thought
Comments are closed.