background image
<< Get Scroll Insensitive Cursor command | Help command >>

Relative command

<< Get Scroll Insensitive Cursor command | Help command >>
Derby Tools and Utilities Guide
42
·
Before First command
·
Close command
·
First command
·
Last command
·
Next command
·
Previous command
·
Relative command
Examples
ij> autocommit off;
ij> get scroll insensitive cursor scrollCursor as
'SELECT * FROM menu';
ij> absolute 5 scrollCursor;
COURSE |ITEM |PRICE
-----------------------------------------------
entree |lamb chop |14
ij> after last scrollcursor;
No current row
ij> before first scrollcursor;
No current row
ij> first scrollcursor;
COURSE |ITEM |PRICE
-----------------------------------------------
entree |lamb chop |14
ij> last scrollcursor;
COURSE |ITEM |PRICE
-----------------------------------------------
dessert |creme brulee |6
ij> previous scrollcursor;
COURSE |ITEM |PRICE
-----------------------------------------------
entree |lamb chop |14
ij> relative 1 scrollcursor;
COURSE |ITEM |PRICE
-----------------------------------------------
dessert |creme brulee |6
ij>>previous scrollcursor;
COURSE |ITEM |PRICE
-----------------------------------------------
dessert |creme brulee |6
ij> next scrollcursor;
COURSE |ITEM |PRICE
-----------------------------------------------
dessert |creme brulee |6
ij> connect 'jdbc:derby:memory:dummy;create=true;user=john'
as john_conn;
ij> create table john_tbl(c int);
0 rows inserted/updated/deleted
ij> insert into john_tbl values(1),(2),(3);
3 rows inserted/updated/deleted
ij> connect 'jdbc:derby:memory:dummy;user=fred' as fred_conn;
ij(FRED_CONN)> get scroll insensitive cursor john_cursor@john_conn
as 'select * from john_tbl';
ij(FRED_CONN)> next john_cursor@john_conn;
C
-----------
1
ij(FRED_CONN)> getcurrentrownumber john_cursor@john_conn;
1
ij(FRED_CONN)> last john_cursor@john_conn;
C
-----------
3
ij(FRED_CONN)> previous john_cursor@john_conn;
C