SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-45
SET STYLE Command
To direct SQLCI to display ten rows at a time, enter:
>> SET LIST_COUNT 10;
>>
To enable the display of statistics and disable continuation of text to the next line,
enter:
>> SET STATISTICS ON, WRAP OFF;
SET STYLE Command
SET STYLE is an SQLCI report writer command that sets style options. Style options
affect the appearance of specific report items, such as underlines, headings, and date
and time formats.
The default settings are:
* resets all style options to their default settings.
SET [ STYLE ] option [ , option ] ... ;
option is:
{ DATE_FORMAT date-format }
{ DECIMAL_POINT { "." | "," }}
{ HEADINGS { ON | OFF } }
{ NEWLINE_CHAR "character" }
{ NULL_DISPLAY "character" }
{ OVERFLOW_CHAR "character" }
{ ROWCOUNT { ON | OFF } }
{ SUBTOTAL_LABEL "label" }
{ TIME_FORMAT time-format }
{ UNDERLINE_CHAR "character" }
{ VARCHAR_WIDTH number }
DATE_FORMAT M2/D2/Y2
DECIMAL_POINT period (.)
HEADINGS ON
NEWLINE_CHAR slash (/)
NULL_DISPLAY question mark (?)
OVERFLOW_CHAR asterisk (*)
ROWCOUNT ON
SUBTOTAL_LABEL *
TIME_FORMAT HP2:M2:S2
UNDERLINE_CHAR hyphen (-)
VARCHAR_WIDTH 80