SQL/MP to SQL/MX Database and Application Migration Guide

HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
Index-3
Migration paths
new NonStop hardware 4
SQL/MP applications to SQL/MX applica-
tions 3
Modules
managing 57
removing after fallback 3
versions 11
Multivalue predicates
See Row-value constructors
MXV
See SQL/MX system software version
(MXV)
N
National character set 34
NCHAR 34
Nonaudited SQL/MX tables, accessing 21
NonStop Solutions Development and Implemen-
tation (SDI) 15
NonStop SQL/MP
coexistence with NonStop SQL/MX 2, 3
migrating to NonStop SQL/MX 1
NonStop SQL/MX
advantages of 2, 1
coexistence with NonStop SQL/MP 2, 3
corequisite independent products 4
feature implementation 3
hardware requirements 1
operating system requirements 2
software versioning 7
version identification 7
O
OBEY command files 9
Object feature version (OFV)
description of 9
displaying 10
Object schema version (OSV)
description of 9
displaying 9
ODBC client applications 7
OFV
See Object feature version (OFV)
Optimizer 4
OSV
See Object schema version (OSV)
P
PARALLEL EXECUTION, index loading 12
Parallelism 5
Partition
comparison between NonStop SQL/MP and
NonStop SQL/MX 11
management 11
Performance, planning for 2
Physical file organization 8
Plan version 8, 10
Planning, migration
assessing current environment 6
choosing applications and objects to migrate
10
determining business objectives 4
NonStop SQL/MP to NonStop SQL/MX 1–5
phases 4
planning the new environment 12
Positioned UPDATE statement 47
Predicates, migrating to NonStop SQL/MX 28
Primary keys 10
Processors 1
Product version identifiers 5
Product version update (PVU) 5
Program invalidation 55
Protection views 13
PROTOTYPE host variables 32
Publish/subscribe 3
PV
See Initial product version (PV)
PVU
See Product version update (PVU)
Q
Query execution plans
displaying 59
forcing 59
optimizing performance 59
Query plan versioning
description of 10
R
READ UNCOMMITTED access, compared to
BROWSE access 25
Referential integrity constraints 10
Release version updates (RVUs) 6
Releases
definition of 1
REPEATABLE access 25
Reserved words 32
RETURN LASTSYSKEY clause 22