What is the difference between SENSITIVE and INSENSITIVE scrollable CURSOR with syntax

The INSENSITIVE SCROLLABLE CURSOR are sort of read only cursors in which the result table cannot change once the cursor is opened. The other applications also cannot update the INSENSITIVE SCROLLABLE CURSOR once it is opened. The SENSITIVE SCROLLABLE CURSOR, unlike INSENSITIVE are sensitive to changes made in the result table. The changes made by other applications will be reflected in the result table.

We can declare SENSITIVE and INSENSITIVE SCROLLABLE CURSOR like below.

EXEC SQL
      DECLARE ORDER_CURR SENSITIVE SCROLL CURSOR FOR
         SELECT ORDER_ID, ORDER_DATE FROM ORDERS
            WHERE ORDER_DATE = ‘2020-07-29’
END-SQL

EXEC SQL
      DECLARE ORDER_CURR INSENSITIVE SCROLL CURSOR FOR
         SELECT ORDER_ID, ORDER_DATE FROM ORDERS
            WHERE ORDER_DATE = ‘2020-07-29’
END-SQL

Mandalika

Updated on 15-Sep-2020 11:10:15

• Related Questions & Answers
• Write the syntax to declare a scrollable cursor on the ORDERS DB2 table.
• What is the purpose and usage of SCROLLABLE CURSOR in COBOLDB2 program?
• What is the usage of scrollable cursor for absolute positioning?
• What is the usage of scrollable cursor for current positioning?
• What is the difference between Parse Tree and the Syntax Tree?
• Difference Between Syntax and Semantics
• How to achieve case sensitive uniqueness and case insensitive search in MySQL?
• What is the difference between = and: = assignment operators?
• What is the difference between g++ and gcc?
• What is the difference between Hinduism and Buddhism?
• What is the difference between IAS and IPS?
• What is the difference between hastily and quickly?
• What is the difference between Osteoporosis and Osteoarthritis?
• What is the difference between deforestation and afforestation?
• What is the difference between home and house?