SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-21
O
NCHAR data (continued)
selecting from SQL/MP tables 6-23
NCHAR data type
associated character sets 6-4
description of 6-20
SQL/MP considerations 1-28, 6-23,
6-64
NCHAR VARYING data type 6-20
Nonaudited tables
CREATE TABLE considerations 2-88
DELETE considerations 2-115
transaction management 1-13
NONSTOP_SQLMX_nodename.SYSTEM_
SCHEMA schema 10-3
NOT NULL constraint 6-8
NOT_NULL_CONSTRAINT_DROPPABLE_
OPTION default 10-39
NULL predicate
examples of 6-99
syntax diagram of 6-98
Null symbol 6-79
NULL, using 2-234
NUMBER_OF_USERS default 10-56
NUMERIC data types
description of 6-33
Numeric data types
approximate numeric 6-33
exact numeric 6-33
literals, examples of 6-75
Numeric literals
approximate 6-74
exact 6-74
examples of 6-75
Numeric value expression
evaluation order 6-51
examples of 6-53
syntax diagram of 6-50
O
OBEY command
examples of 4-42
syntax diagram of 4-41
OBEY command file 4-41
Object names 6-12
Object namespace 6-14
Objects
DEFINE names 6-13
description of 6-12
logical names 6-12, 6-13
name types
default 6-15
mixing 6-15
naming 10-47
physical names 6-12
OBJECTS metadata table 10-18
OCTET_LENGTH function
CHAR_LENGTH similarity to 9-101
examples of 9-101
syntax diagram of 9-101
OFFSET function
examples of 9-102
syntax diagram of 9-102
OLT optimization
See Online transaction optimization
OLT_QUERY_OPT default 10-56
Online transaction optimization (OLT)
Explain token display 4-17
OLT_QUERY_OPT 10-56
OPEN statement
C examples of 3-75
COBOL examples of 3-76
scope of 3-73
static and dynamic forms 3-73
syntax diagram of 3-73
OPTIMIZATION_LEVEL default 10-56
OPTS_PUSH_DOWN_DAM default 10-56