SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-32
P
ORDER BY clause (continued)
relation to break groups B-8
SELECT statement S-23
ORDERING, in KEYS table K-1
ORGANIZATION clause, CREATE TABLE
statement C-158
Organization of files F-8
Orphans, preventing in report D-49
OSS names O-6
OSS processes E-2
OSSFILE, in PROGRAMS table P-32
OUT command
CLEAR option O-7
description of O-7
OUT file
description of O-7
displaying name of E-3
Outer joins J-1
Outer query S-83
Outer reference S-83
Output
device width R-20, S-42
directing to a file O-7
host variables D-43
lines, truncating or wrapping S-42
Output host variables D-43
OUT_REPORT command O-8
OUT_REPORT file
current O-9
displaying name of E-3
specifying O-8
OVERFLOW_CHAR layout option O-10,
R-10
OWNER file attribute
ALTER CATALOG statement A-8
ALTER COLLATION statement A-10
ALTER PROGRAM statement A-27
ALTER TABLE statement A-32
ALTER VIEW statement A-50
description of O-10
SECURE command S-8
Ownership
displaying D-56, F-12
of a file, description of S-14
Ownership changing
program A-27
table A-32
Owner, generalized G-1, S-9, S-14
P
Packed record length F-16
PAD option
COPY command C-119
LOAD command L-22
Page
advancing to next D-49
conditional break D-48
length P-2
maximum in report P-1
size for PERUSE O-9
text at bottom of P-1
PAGE clause
DETAIL command D-49
report writer option R-11
PAGE FOOTING command
AS clause A-60
COMPUTE_TIMESTAMP
function C-62
CONCAT clause C-63
CURRENT_TIMESTAMP
function C-174
description of P-1
IF/THEN/ELSE clause I-1
PAGE TITLE command
AS clause A-60
COMPUTE_TIMESTAMP
function C-62
CONCAT clause C-63
CURRENT_TIMESTAMP
function C-174
description of P-4