1.1

Description
After the cursor is created with the get scroll insensitive cursor on page 434 command, moves the cursor to the
last row in the ResultSet, then fetches the row. It displays a banner and the values of the row.
Example
sqlf(PEERCLIENT)> get scroll insensitive with nohold cursor
scrollCursor as 'select * from firsttable order by id';
sqlf(PEERCLIENT)> absolute 3 scrollCursor;
ID |NAME
------------------------
30 |THIRTY
sqlf(PEERCLIENT)> first scrollCursor;
ID |NAME
------------------------
10 |TEN
sqlf(PEERCLIENT)> next scrollCursor;
ID |NAME
------------------------
20 |TWENTY
sqlf(PEERCLIENT)> last scrollCursor;
ID |NAME
------------------------
50 |Fifty
LocalizedDisplay
Specifies whether to display locale-sensitive data (such as dates) in the native format for the sqlf locale.
Syntax
LOCALIZEDDISPLAY { on | off }
Description
Specifies whether to display locale-sensitive data (such as dates) in the native format for the sqlf locale. The
sqlf locale is the same as the Java system locale.
Note: NUMERIC and DECIMAL values are not localized when the J2ME/CDC/Foundation Profile is
used, because of platform limitations.
Example
The following demonstrates LocalizedDisplay in an English locale:
sqlf(PEERCLIENT)> VALUES CURRENT_DATE;
1
----------
2011-05-16
1 row selected
sqlf(PEERCLIENT)> localizeddisplay on;
437
sqlf Interactive Commands