SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-30
O
NO PROGID file attribute, description
of P-28
NOAUDITCOMPRESS attribute, turned off
for WITH SHARED ACCESS W-6
Nonaudited objects
consistency considerations for T-9
control opens C-77
FREE RESOURCES
considerations F-30
lock holder L-50
lock release summary L-48
Nonaudited tables
BUFFERED file attribute B-11
description of N-4
unlocking U-1
virtual sequential block
buffering(VSBB) C-89
NONEMPTYBLOCKCOUNT, in FILES
table F-28
NonStop SMF S-78
NonStop SQL/MP
dictionary D-1
statements S-73
statements, catalog tables and C-9
version information from
FILEINFO F-16
versions of components V-6
NonStop Storage Management Foundation
(SMF) S-78
Nonunique indexes I-9
NOPURGEUNTIL
ALTER CATALOG statement A-8
file attribute N-5
in FILES table F-27
NOSCRATCHON, parameter for
FastSort Z-4
NOT NULL clause, CREATE TABLE
statement C-157
NOT operator S-5
NOTCPUS, parameter for FastSort Z-4
NULL predicate N-6
NULL STRUCTURE clause, INVOKE
directive I-27
Null values
and aggregate functions A-77
and AVG A-77
and COUNT C-130
and index sorting C-149
and INSERT I-17
and MAX M-2
and MIN M-4
and SUM S-89
and unique index C-143
copying from Enscribe C-117
defining columns N-8
description of N-7
expression evaluation N-9, N-10
for Enscribe fields L-23
inserting I-14
loading from Enscribe L-23
specifying for UPDATE U-3
use in partitioned indexes P-17
NULLALLOWED in COLUMNS table C-46
NULL_DISPLAY layout option N-10, R-10
Numbering lines in a report L-14
Numbers, comparing C-59
Numeric
data, comparing C-59
expressions E-22
literals N-13
NUMERIC data syntax D-4
Numeric data types
description of N-11
exact N-11, N-12
O
OBEY command O-1
OBEY command files O-1
Object type, displaying F-15