NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
R-12
Report Writer Clauses
Report Writer Clauses
Report Writer Functions
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
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
NEED Number of lines to keep together on page
PAGE Advance to the next page and optionally start a new page-number
sequence
SKIP Number of lines before next item
SPACE Number of blanks between items
TAB Position of the next item on a line
Function What the Function Returns
COMPUTE_TIMESTAMP Timestamp for specified date and time
CURRENT_TIMESTAMP Timestamp for current date and time
LINE_NUMBER Current line number within a break group, page, or
report
PAGE_NUMBER Current page number
Option What the Option Defines Default