SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-23
O
NOT NULL constraint 6-9
NOT_NULL_CONSTRAINT_DROPPABLE_
OPTION default 10-47
NULL predicate
examples of 6-100
syntax diagram of 6-99
Null symbol 6-80
NULL, using 2-256
NUMBER_OF_USERS default 10-67
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
O
OBEY command
examples of 4-57
syntax diagram of 4-56
OBEY command file 4-56
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-57
physical names 6-13
OBJECTS metadata table 10-21
OCTET_LENGTH function
CHAR_LENGTH similarity to 9-109
examples of 9-109
syntax diagram of 9-109
OFFSET function
examples of 9-110
syntax diagram of 9-110
OLT optimization
See Online transaction optimization
OLT_QUERY_OPT default 10-67
Online transaction optimization (OLT)
OLT_QUERY_OPT 10-67
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-68
OPTS_PUSH_DOWN_DAM default 10-68
P
PARALLEL_NUM_ESPS default 10-68
Parameter specification
examples of 6-79
names 6-78
type assignments 6-77
Parameters in dynamic SQL, restrictions on
use 2-184
PARTITION clause
examples 7-7
syntax diagram of 7-5
Partition Overlay Specification (POS)
default attributes 10-60
description of 2-94
Partitioning key
CREATE INDEX, FIRST KEY
specification 2-57