SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-38
R
Report
cancelling C-2
centering contents of C-12
copies O-9
default format D-50
default right margin L-53
file, closing O-8
file, specifying O-8
file, specifying or closing O-8
form feed for P-2
form name O-9
headings D-50
line length D-50
logical lines D-50
naming O-9
number of copies, specifying O-9
number of rows before pause S-41
numbering lines L-14
page size for PERUSE O-9
preventing orphans D-49
preventing widows D-49
summaries D-50
width L-53
REPORT FOOTING command
AS clause A-60
COMPUTE_TIMESTAMP
function C-62
CONCAT clause C-63
CURRENT_TIMESTAMP
function C-174
description of R-2
IF/THEN/ELSE clause I-1
Report formatting commands
deleting stored R-16
saving in file S-2
Report layout options
CENTER_REPORT C-12
, R-10
DATE_FORMAT D-8, R-10
DECIMAL_POINT D-22, R-10
HEADINGS H-2, R-10
Report layout options (continued)
LEFT_MARGIN L-1, R-10
LINE_SPACING L-16, R-10
LOGICAL_FOLDING L-53, R-10
NEWLINE_CHAR N-4, R-10
NULL_DISPLAY N-10, R-10
OVERFLOW_CHAR O-10, R-10
PAGE_COUNT P-1, R-10
PAGE_LENGTH P-2, R-10
RIGHT_MARGIN R-10, R-20
ROWCOUNT R-10, R-23
SPACE R-10, S-58
SUBTOTAL_LABEL R-10, S-88
TIME_FORMAT R-10, T-4
UNDERLINE_CHAR R-10, U-1
VARCHAR_WIDTH R-10, V-1
WINDOW R-10, W-2
REPORT option, SAVE command S-3
REPORT TITLE command
AS clause A-60
COMPUTE_TIMESTAMP
function C-62
CONCAT clause C-63
CURRENT_TIMESTAMP
function C-174
description of R-6
IF/THEN/ELSE clause I-1
Report writer R-7
Report writer clauses
AS A-60
AS DATE/TIME A-67
CONCAT C-63
IF/THEN/ELSE I-1
NEED D-49
PAGE D-49
SKIP D-49
SPACE D-49
TAB D-49