SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-23
O
SQL/MP considerations 1-31, 6-25,
6-66
NCHAR VARYING data type 6-23
Nonaudited tables
CREATE TABLE considerations 2-114
DELETE considerations 2-157
transaction management 1-17
NONSTOP_SQLMX_nodename.SYSTEM_
SCHEMA schema 10-7
NOT NULL constraint 6-9
NOT_NULL_CONSTRAINT_DROPPABLE_
OPTION default 10-51
NULL predicate
examples of 6-100
syntax diagram of 6-99
Null symbol 6-80
NULL, using 2-313
NUMBER_OF_USERS default 10-73
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 9-123
NVL2 Function 9-125
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-62
physical names 6-13
OBJECTS metadata table 10-24
OCTET_LENGTH function
CHAR_LENGTH similarity to 9-126
examples of 9-127
syntax diagram of 9-126
OFFSET function
examples of 9-128
syntax diagram of 9-128
OLT optimization
See Online transaction optimization
OLT_QUERY_OPT default 10-73
Online transaction optimization (OLT)
OLT_QUERY_OPT 10-73
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-73
OPTS_PUSH_DOWN_DAM default 10-73
P
PARALLEL_NUM_ESPS default 10-73
Parameter specification
examples of 6-79
names 6-78
type assignments 6-77