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
- Here’s the Top Command to Change Shells in Ubuntu Quickly
- How to Resolve -206 SQL Error Object-Not-Valid in DB2
- 3 File Descriptors in Unix Operating System: What They Mean
- Shell Script Tricky Question – Duplicate Functions
- 13 Tricky AWS Simple Workflow Interview Questions
One thought
Comments are closed.