1.0

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 397
• after last on page 398
• before first on page 400
• close on page 400
• first on page 407
• last on page 410
• next on page 412
• previous on page 414
• relative on page 415
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
409
sqlf Interactive Commands