NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
R-11
Style and Layout Options for Reports
Style and Layout Options for Reports
RESET REPORT Deletes commands from the current report definition, or
deletes columns or alias from stored report formatting
commands in the current report definition
RESET SESSION Resets session options to default settings
RESET STYLE Resets style options to default settings
SELECT Retrieves data from tables and views
SET LAYOUT Sets layout options to new values
SET SESSION Sets session options to new values
SET STYLE Sets style options to new values
SHOW LAYOUT Displays the values of layout options
SHOW REPORT Displays report formatting commands and the most recent
SELECT command
SHOW SESSION Displays values of session options
SHOW STYLE Displays values of style options
SUBTOTAL Defines subtotals
TOTAL Defines totals
Option What the Option Defines Default
CENTER_REPORT Is report centered? OFF
DATE_FORMAT Format for dates M2/D2/Y2
DECIMAL_POINT Symbol for decimal point Period (.)
HEADINGS Are headings used? ON
LEFT_MARGIN Left margin 0
LINE_SPACING Number of lines to advance before
next report line
1
LOGICAL_FOLDING Does item of default detail line
move to the next line when it does
not fit in margins?
ON
NEWLINE_CHAR Character to indicate a new line in
a heading
Slash (/)
NULL_DISPLAY Character to represent a null value Question mark (?)
OVERFLOW_CHAR Filler character printed when a
value exceeds the field size
Asterisk (*)
PAGE_COUNT Maximum pages ALL
PAGE_LENGTH Maximum lines per page ALL for terminal
60 for other devices
Command
Description