background image
<< Relative command | MaximumDisplayWidth command >>

Help command

<< Relative command | MaximumDisplayWidth command >>
Derby Tools and Utilities Guide
43
-----------
2
ij(FRED_CONN)> first john_cursor@john_conn;
C
-----------
1
ij(FRED_CONN)> after last john_cursor@john_conn;
No current row
ij(FRED_CONN)> before first john_cursor@john_conn;
No current row
ij(FRED_CONN)> relative 2 john_cursor@john_conn;
C
-----------
2
ij(FRED_CONN)> absolute 1 john_cursor@john_conn;
C
-----------
1
ij(FRED_CONN)> close john_cursor@john_conn;
ij(FRED_CONN)> disconnect all;
ij>
Help command
Syntax
HELP
Description
Prints out a brief list of the
ij
commands.
Last command
Syntax
LAST
Identifier
Description
Moves the cursor to the last row in the ResultSet, then fetches the row. The cursor must
have been created with the
Get Scroll Insensitive Cursor
command. It displays a banner
and the values of the row.
Example
ij> get scroll insensitive cursor scrollCursor as
'SELECT * FROM menu FOR UPDATE OF price';
ij> absolute 5 scrollCursor;
COURSE |ITEM |PRICE
-----------------------------------------------
entree |lamb chop |14
ij> last scrollcursor;
COURSE |ITEM |PRICE
-----------------------------------------------
dessert |creme brulee |6
LocalizedDisplay command
Syntax
LOCALIZEDDISPLAY { on | off }
Description