NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-32
O
Operable plan P-21
Operation cost, in EXPLAIN report E-18
Operations on catalog tables C-8
Operators
AND S-5
arithmetic and unary E-22
Boolean or logical S-5
comparison C-55
NOT S-5
OR S-5
Optimal plan P-21
Options
CENTER_REPORT C-10
COMMIT C-46
DATE FORMAT D-8
DECIMAL POINT D-20
HEADINGS H-1
LEFT_MARGIN L-1
LINE_SPACING L-14
LOGICAL_FOLDING L-50
NAME N-2
NEWLINE_CHAR N-3
NULL_DISPLAY N-10
OVERFLOW_CHAR O-9
PAGE_COUNT P-1
PAGE_LENGTH P-2
REPORT R-3
resetting R-22
RIGHT MARGIN R-22
ROLLBACK C-49
ROWCOUNT R-25
setting S-46
SPACE S-58
SUBTOTAL_LABEL S-87
TIME_FORMAT T-4
UNDERLINE_CHAR U-1
VARCHAR_WIDTH V-1
WINDOW W-2
WITH SHARED ACCESS W-4
OR operator S-5
ORDER BY clause
and null values N-9
and UNION operator S-26
relation to break groups B-9
SELECT statement S-22
ORDERING, in KEYS table K-1
ORGANIZATION clause, CREATE TABLE
statement C-148
Organization of files F-8
Orphans, preventing in report D-46
OSS names O-6
OSS processes E-2
OSSFILE, in PROGRAMS table P-31
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-81, S-82
Outer reference S-82
Output
device width R-22
, S-42
directing to a file O-7
lines, truncating or wrapping S-42
Output host variables D-41
OUT_REPORT command O-8
OUT_REPORT file
current O-9
displaying name of E-3
specifying O-8
OVERFLOW_CHAR layout option O-9,
R-11
OWNER file attribute
ALTER CATALOG statement A-8
ALTER COLLATION statement A-9
ALTER PROGRAM statement A-25