SQL/MP Report Writer Guide

Using SQLCI and the Report Writer
HP NonStop SQL/MP Report Writer Guide—527213-001
2-4
Setting Up Your Session Environment
truncated, and whether warning messages are displayed. Figure 2-2 illustrates the
setting and displaying options.
You can use the RESET, RESET LAYOUT, and RESET STYLE commands to reset
specific options or all options to their default values. For example, the following
commands reset the line spacing to 1 (single spacing) and reset all style options to
their default values:
>> RESET LAYOUT LINE_SPACING;
>> RESET STYLE * ;
You can enter SET, RESET, and SHOW commands at the standard SQLCI prompt
(>>) or the select-in-progress prompt (S>).
In the tasks described in this manual, you can see more illustrations of how options
affect your reports. Except for LIST_COUNT, all options are set to their default values
unless the example specifically sets the option. All examples have LIST_COUNT set to
Figure 2-2. Setting and Displaying Options
>> SET STYLE DATE_FORMAT "DA, MA Y4",
+> SUBTOTAL_LABEL "Subtotal", UNDERLINE_CHAR "=";
>> SHOW LAYOUT RIGHT_MARGIN ;
RIGHT_MARGIN 80
>> SHOW STYLE *;
-------------------------------------------------------------------------
Current STYLE Option Values
-------------------------------------------------------------------------
DATE_FORMAT DA, MA Y4
DECIMAL_POINT
.
HEADINGS ON
NEWLINE_CHAR /
NULL_DISPLAY ?
OVERFLOW_CHAR *
ROWCOUNT ON
SUBTOTAL_LABEL Subtotal
TIME_FORMAT HP2:M2:S2
UNDERLINE_CHAR =
VARCHAR_WIDTH 80
VST0202.vsd