Why DB2 is becoming such a popular database? Yes, there are many reasons. Time to time it is upgrading with latest features. We know CURSORS is DB2 object. There are some advanced concepts, we need to learn.
Some Key words:
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.