SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-22
O
Name resolution 10-53
NAME2ID metadata table 10-86
Namespace 6-15
NAMETYPE default 10-51
NATIONAL CHAR data type 6-21
NATIONAL CHAR VARYING data
type 6-21
National character set
default attribute 10-50
N string literals 6-61, 6-62
NATIONAL_CHARSET default 10-50
NATURAL join, description of 2-206
NATURAL LEFT join, description of 2-206
NATURAL RIGHT join, description of 2-206
NCHAR data
inserting into SQL/MP columns 6-63,
6-64
selecting from SQL/MP tables 6-23
NCHAR data type
associated character sets 6-5
description of 6-21
SQL/MP considerations 1-29, 6-23,
6-63
NCHAR VARYING data type 6-21
Nonaudited tables
CREATE TABLE considerations 2-94
DELETE considerations 2-120
transaction management 1-15
NONSTOP_SQLMX_nodename.SYSTEM_
SCHEMA schema 10-3
NOT NULL constraint 6-9
NOT_NULL_CONSTRAINT_DROPPABLE_
OPTION default 10-42
NULL predicate
examples of 6-97
syntax diagram of 6-96
Null symbol 6-77
NULL, using 2-253
NUMBER_OF_USERS default 10-62
NUMERIC data type 6-33
Numeric data types
approximate numeric 6-32
exact numeric 6-32
literals, examples of 6-73
Numeric literals
approximate 6-73
exact 6-73
examples of 6-73
Numeric value expression
evaluation order 6-50
examples of 6-52
syntax diagram of 6-49
O
OBEY command
examples of 4-46
syntax diagram of 4-45
OBEY command file 4-45
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-51
physical names 6-13
OBJECTS metadata table 10-19
OCTET_LENGTH function
CHAR_LENGTH similarity to 9-105
examples of 9-105
syntax diagram of 9-105
OFFSET function
examples of 9-106
syntax diagram of 9-106
OLT optimization
See Online transaction optimization