Write the syntax to declare a scrollable cursor on the ORDERS DB2 table.

DB2DatabaseBig Data Analytics

A SCROLLABLE CURSOR can move in both forward and backward direction. In other words, it can fetch next as well as previous rows. A SCROLLABLE CURSOR is declared using the “SCROLL” clause in the DECLARE CURSOR.

For example, if we want to declare a SCROLLABLE CURSOR on the ORDERS table then we have to declare the cursor like below.

EXEC SQL
      DECLARE ORDER_CURR SCROLL CURSOR FOR
         SELECT ORDER_ID, ORDER_DATE FROM ORDERS
            WHERE ORDER_DATE = ‘2020-07-29’
END-SQL
raja
Published on 15-Sep-2020 14:37:51
Advertisements