1.1

Scroll-insensitive result sets are not capable of scrolling. That means the cursor can move in only one direction.
When the result set is open, any change to the database table will not reflect.
Unlike Scroll-insensitive, the Scroll-sensitive result set can move the cursor bidirectionally. It also enables the
changes to the database tables when the result set is open. This is the default for sqlf scrollable cursor.
Once a scrollable cursor is created, use the following commands to work with the result set:
• absolute on page 423
• after last on page 424
• before first on page 426
• close on page 426
• first on page 433
• last on page 436
• next on page 438
• previous on page 440
• relative on page 441
Example
sqlf(PEERCLIENT)> get with nohold cursor scrollCursor as
'select *
from firsttable';
--another connection performs the following operations.
sqlf> select * from firsttable;
ID |NAME
------------------------
40 |Forty
20 |TWENTY
30 |THIRTY
10 |TEN
50 |Fifty
5 rows selected
sqlf> update firsttable set name='FORTY' where id=40;
1 row inserted/updated/deleted
--the sensitive cursor reflects the update
sqlf(PEERCLIENT)> next scrollCursor;
ID |NAME
------------------------
40 |FORTY
--scroll insensitive cursor
sqlf(PEERCLIENT)> get scroll insensitive with nohold cursor
scrollCursor
as 'select * from firsttable';
--another connection performs the following operation.
sqlf> update firsttable set name='Forty' where id=40;
1 row inserted/updated/deleted
--the insensitive cursor does not reflect the update
sqlf(PEERCLIENT)> next scrollCursor;
ID |NAME
435
sqlf Interactive Commands