SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-23
O
Nonaudited tables
CREATE TABLE considerations 2-114
DELETE considerations 2-152
transaction management 1-16
NONSTOP_SQLMX_nodename.SYSTEM_
SCHEMA schema 10-3
, 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-300
NUMBER_OF_USERS default 10-70
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-118
NVL2 Function 9-120
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-60
physical names 6-13
OBJECTS metadata table 10-23
OCTET_LENGTH function
CHAR_LENGTH similarity to 9-121
examples of 9-122
syntax diagram of 9-121
OFFSET function
examples of 9-123
syntax diagram of 9-123
OLT optimization
See Online transaction optimization
OLT_QUERY_OPT default 10-70
Online transaction optimization (OLT)
OLT_QUERY_OPT 10-70
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-225
PARTITION clause
examples 7-8