DB2- Advanced Programming With Cursors Part (2 of 2)

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.

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.