SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-23
O
transaction management 1-16
NONSTOP_SQLMX_nodename.SYSTEM_
SCHEMA schema 10-7
NOT NULL constraint 6-9
NOT_NULL_CONSTRAINT_DROPPABLE_
OPTION default 10-50
NULL predicate
examples of 6-100
syntax diagram of 6-99
Null symbol 6-80
NULL, using 2-388
NUMBER_OF_USERS default 10-71
NUMERIC data type 6-35
Numeric data types
approximate numeric 6-35
exact numeric 6-35
extended numeric 6-18
literals, examples of 6-76
Numeric literals
approximate 6-76
exact 6-76
examples of 6-76
Numeric value expression
evaluation order 6-53
examples of 6-55
syntax diagram of 6-52
NVL 8-123
NVL2 Function 8-125
O
OBEY command
examples of 4-58
syntax diagram of 4-57
OBEY command file 4-57
Object names 6-13
Object namespace 6-15
Objects
DEFINE names 6-14
description of 6-13
logical names 6-13, 6-14
name types
default 6-16
mixing 6-16
naming 10-60
physical names 6-13
OBJECTS metadata table 10-22
OCTET_LENGTH function
CHAR_LENGTH similarity to 8-126
examples of 8-127
syntax diagram of 8-126
OFFSET function
examples of 8-128
syntax diagram of 8-128
OLT optimization
See Online transaction optimization
OLT_QUERY_OPT default 10-71
Online transaction optimization (OLT)
OLT_QUERY_OPT 10-71
OPEN statement
C examples of 3-74
COBOL examples of 3-75
scope of 3-72
static and dynamic forms 3-72
syntax diagram of 3-72
OPTIMIZATION_LEVEL default 10-71
OPTS_PUSH_DOWN_DAM default 10-71
P
PARALLEL_NUM_ESPS default 10-71
Parameter specification
examples of 6-79
names 6-78
type assignments 6-77
Parameters in dynamic SQL, restrictions on
use 2-300
PARTITION clause
examples 7-8
syntax diagram of 7-6
Partition Overlay Specification (POS)
default attributes 10-63