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
- Quick SQL Interview Questions for Data Engineers (Little Tricky)
- AWS Glue Crawler Issue with Dynamic S3 Folder Paths? Here’s the Complete Fix
- How to Create a Generic Stored Procedure for KPI Calculation (SQL + AWS Lambda)
- Unlocking the Power of Databricks Genie: A Comprehensive Guide
- Secure S3 File Upload Using API Gateway, Lambda & PostgreSQL (Complete AWS Architecture Guide
Srinimf 
One response
[…] Advanced Programming with cursors […]
LikeLike