SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-31
O
Objects
deleting damaged C-21
dependencies U-15, V-7
determining catalog in which
defined F-16
dropping P-33
names of G-7
programs as P-31
versions V-7
Objects displaying
ownership of D-56
security of D-56
use of D-54
OBJECTVERSION
in INDEXES table I-10
in TABLES table T-3
OBJNAME, in COMMENTS table C-51
OBJSUBNAME, in COMMENTS table C-51
OBJTYPE, in COMMENTS table C-51
OC modifier O-10
OCTET_LENGTH function O-4
OFFSET in COLUMNS table C-46
One-way partition split, ALTER TABLE
statement A-40
Online dumps W-5, W-6
On-demand opens C-82
OPEN option, CONTROL TABLE
directive C-82
Open state of file F-11
OPEN statement
and SQLDA O-5
cursors O-5
description of O-5
USING DESCRIPTOR clause O-5
Open states, file F-19
Opening and closing tables T-1
Opens, on-demand C-82
Operable plan P-22
Operation cost, in EXPLAIN report E-18
Operations on catalog tables C-9
Operators
AND S-5
Boolean or logical S-5
comparison C-60
NOT S-5
OR S-5
Optimal plan P-22
Options
CENTER_REPORT C-12
COMMIT C-52
DATE FORMAT D-8
DECIMAL POINT D-22
HEADINGS H-2
LEFT_MARGIN L-1
LINE_SPACING L-16
LOGICAL_FOLDING L-53
NAME N-2
NEWLINE_CHAR N-4
NULL_DISPLAY N-10
OVERFLOW_CHAR O-10
PAGE_COUNT P-1
PAGE_LENGTH P-2
REPORT R-3
resetting R-19
RIGHT MARGIN R-20
ROLLBACK C-55
ROWCOUNT R-23
setting S-45
SPACE S-58
SUBTOTAL_LABEL S-88
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