NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-31
O
NOT operator S-5
NOTCPUS, parameter for FastSort Z-4
NULL predicate N-5
NULL STRUCTURE clause, INVOKE
directive I-27
Null values
and aggregate functions A-71
and AVG A-71
and COUNT C-126
and index sorting C-140
and INSERT I-17
and MAX M-1
and MIN M-4
and SUM S-89
and unique index C-134
copying from Enscribe C-113
defining columns N-7
description of N-6
expression evaluation N-9, N-10
inserting I-14
loading from Enscribe L-22
specifying for UPDATE U-3
use in partitioned indexes P-17
NULLALLOWED in COLUMNS
table C-42
NULL_DISPLAY layout option N-10, R-11
Numbering lines in a report L-12
Numbers, comparing C-54
Numeric
data types N-11
expressions E-23
literals N-13
NUMERIC data syntax D-4
Numeric data types, exact N-12, N-13
Numeric data, comparing C-54
O
OBEY command O-1
OBEY files O-1
Object type, displaying F-16
Objects
deleting damaged C-19
dependencies U-15, V-7
determining catalog in which
defined F-17
displaying
ownership of D-53
security of D-53
use of D-51
dropping P-31
names of G-7
programs as P-30
versions V-7
OBJECTVERSION
in INDEXES table I-10
in TABLES table T-2
OBJNAME, in COMMENTS table C-46
OBJSUBNAME, in COMMENTS
table C-46
OBJTYPE, in COMMENTS table C-46
OC modifier O-9
OCTET_LENGTH function O-4
of numeric results E-25
OFFSET in COLUMNS table C-41
One-way partition split, ALTER TABLE
statement A-37, A-38
Online dumps W-5, W-6
On-demand opens C-76
OPEN option, CONTROL TABLE
directive C-76
Open state of file F-12
OPEN statement
and SQLDA O-5
cursors O-5
description of O-4
USING DESCRIPTOR clause O-5
Open states, file F-19
Opening and closing tables T-1
Opens, on-demand C-76