In this post, you will learn advanced cursor concepts in DB2. As you may know, a cursor is a DB2 object. In a previous post on DB2 cursors, I explained how to use them in your programs. In this post, you will learn the key 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
