MaximumDisplayWidth command
Derby Tools and Utilities Guide
44
Specifies to display locale-sensitive data (such as dates) in the native format for the
ij
locale. The
ij
locale is the same as the Java system locale.
Note: NUMERIC and DECIMAL values are not localized when using the
J2ME/CDC/Foundation Profile because of platform limitations.
Example
The following demonstrates LocalizedDisplay in an English locale:
ij> VALUES CURRENT_DATE;
1
----------
2000-05-01
1 row selected
ij> localizeddisplay on;
ij> VALUES CURRENT_DATE;
1
------------------
May 1, 2000
1 row selected
MaximumDisplayWidth command
Syntax
MAXIMUMDISPLAYWIDTH integer_value
Description
Sets the largest display width for columns to the specified value. This is generally used to
increase the default value in order to display large blocks of text.
Example
ij> maximumdisplaywidth 3;
ij> VALUES 'NOW IS THE TIME!';
1
---
NOW
ij> maximumdisplaywidth 30;
ij> VALUES 'NOW IS THE TIME!';
1
----------------
NOW IS THE TIME!
Next command
Syntax
NEXT
Description
Fetches the next row from the named cursor created with the
. It displays a banner and the values of the row.
Example
ij> get cursor menuCursor as 'SELECT * FROM menu';
ij> next menuCursor;
COURSE |ITEM |PRICE
-----------------------------------------------
entree |lamb chop |14
ij>
