SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
R-10
Report Writer
Table R-2. Style and Layout Options for Reports
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
RIGHT_MARGIN Right margin Device width
SPACE Spaces between columns 2
ROWCOUNT Is the row-count line generated? ON
SUBTOTAL_LABEL Label to print in a break column with
subtotals
Asterisk (*)
TIME_FORMAT Format for time HP2:M2:S2
UNDERLINE_CHAR Character for underlining Hyphen (-)
VARCHAR_WIDTH Maximum characters in a varying-length
print item
80
WINDOW Column position displayed at the left
edge of output device
TAB 1
Table R-3. Report Writer Clauses (page1of2)
Clause What the Clause Specifies
AS Format for a print item
AS DATE/TIME Format for a printed date or time
CONCAT Print items without intervening space
IF/THEN/ELSE Condition for printing items