SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-22
O
NCHAR data
inserting into SQL/MP columns 6-62,
6-63
selecting from SQL/MP tables 6-22
NCHAR data type
associated character sets 6-4
description of 6-20
SQL/MP considerations 1-29, 6-22,
6-62
NCHAR VARYING data type 6-20
Nonaudited tables
CREATE TABLE considerations 2-88
DELETE considerations 2-113
transaction management 1-15
NONSTOP_SQLMX_nodename.SYSTEM_
SCHEMA schema 10-3
NOT NULL constraint 6-8
NOT_NULL_CONSTRAINT_DROPPABLE_
OPTION default 10-40
NULL predicate
examples of 6-96
syntax diagram of 6-95
Null symbol 6-76
NULL, using 2-229
NUMBER_OF_USERS default 10-57
NUMERIC data type 6-32
Numeric data types
approximate numeric 6-31
exact numeric 6-31
literals, examples of 6-72
Numeric literals
approximate 6-72
exact 6-72
examples of 6-72
Numeric value expression
evaluation order 6-49
examples of 6-51
syntax diagram of 6-48
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-48
physical names 6-12
OBJECTS metadata table 10-19
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-57
Online transaction optimization (OLT)
Explain token display 4-17
OLT_QUERY_OPT 10-57
OPEN statement
C examples of 3-73
COBOL examples of 3-74
scope of 3-71
static and dynamic forms 3-71
syntax diagram of 3-71
OPTIMIZATION_LEVEL default 10-57
OPTS_PUSH_DOWN_DAM default 10-57