Purpose of INSENSITIVE SCROLL CURSOR FOR statement in cursor

GaganGarg · Active User Joined: 31 Mar 2010 Posts: 134 Location: India

Hi,

Can anybody please let me know the purpose of using the statement INSENSITIVE SCROLL CURSOR FOR while declaring the cursor?

one issue was found in our program and our onsite told the following reason:

CICS Guy · Posted: Mon Jun 21, 2010 8:40 pm

Have you looked at the manual under ASENSITIVE, INSENSITIVE and SENSITIVE?
INSENSITIVE
Specifies that the cursor does not have sensitivity to inserts, updates, or deletes that are made to the rows underlying the result table. As a result, the size of the result table, the order of the rows, and the values for each row do not change after the cursor is opened. In addition, the cursor is read-only. The SELECT statement or attribute-string of the PREPARE statement cannot contain a FOR UPDATE clause, and the cursor cannot be used for positioned updates or deletes. ?

Pradip kumar Mohanty · New User Joined: 16 Sep 2007 Posts: 33 Location: India

STATIC or DYANAMIC ? STATIC SENSITIVE combo will not let INSERTS be reflected in the result set. DYNAMIC will show the actual change.

A little more information on how the logic flows would let us to come up with more specific answer.

GaganGarg · Active User Joined: 31 Mar 2010 Posts: 134 Location: India

Hi Pradip,

Thanks for your reply. we used INSENSITIVE SCROLL CURSOR FOR clause and i think by default it is STATIC only. It worked fine after giving this clause with the cursor declaration.