SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

Index
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
Index-5
N
Multivalue predicates
See Row-value constructors
MXCI script, migrating from SQL/MX
Release 1.8 to SQL/MX Release 2.x 7-2
MXCS client, migrating from SQL/MX
Release 1.8 to SQL/MX Release 2.x 7-2
MXV
See SQL/MX system software version
(MXV)
N
NAME2ID metadata table 6-4
National character set 10-34
NCHAR 10-34
Nonaudited SQL/MX tables,
accessing 10-21
NonStop Solutions Development and
Implementation (SDI) 1-20
NonStop SQL/MP
coexistence with NonStop
SQL/MX 1-3
, 5-4, 9-4
migrating to NonStop SQL/MX 10-1,
11-1
NonStop SQL/MX
advantages of 1-7
, 10-2, 11-1
coexistence with NonStop
SQL/MP 1-3
, 5-4, 9-4
corequisite independent products 9-4
feature implementation 9-3
hardware requirements 9-1
operating system requirements 9-2
software versioning 2-9
version identification 2-9
versioning 2-1
NonStop system, advantages 1-7
O
OBEY command files 10-9
Object feature version (OFV)
description of 2-12
displaying 2-12
Object schema version (OSV)
description of 2-11
displaying 2-11
OBJECTS metadata table 6-3, 6-4
ODBC client applications 10-7
OFV
See Object feature version (OFV)
Optimizer 10-4
ORDERED_HASH_JOIN operator 7-8
OSV
See Object schema version (OSV)
P
PARALLEL EXECUTION, index
loading 11-12
Parallelism 10-5
PARAMS metadata table, migrating 6-11
Partition
comparison between NonStop SQL/MP
and NonStop SQL/MX 11-11
management 11-12
Performance, planning for 5-2, 9-2
Phased migration 1-5
Physical file organization 11-8
Plan version 2-10, 2-13
Planning, migration
assessing current environment 1-10
choosing applications and objects to
migrate 1-15
determining business objectives 1-9
NonStop SQL/MP to NonStop
SQL/MX 9-1
/9-5
phases 1-9
planning the new environment 1-17
SQL/MX Release 1.8 to SQL/MX
Release 2.x 5-1
/5-5
Positioned UPDATE statement 10-47
Predicates, migrating to NonStop
SQL/MX 10-28
Primary keys 11-10
Processors 5-1, 9-1