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-1
A
Access options, STABLE access 25
Aggregate predicates 29
ANSI compliance 2
Assistance 15
Auto-abort 20
Automatic recompilation, warnings 55
B
BEGIN WORK statement 20
Business objectives, determining 4
C
CA release
See Controlled availability (CA) release
Capacity planning
NonStop SQL/MP to NonStop SQL/MX 2
CAST function
and descriptor area 48
data conversion 44
Catalogs, user 5
Character sets 34
Clustering keys 10
Coexistence, NonStop SQL/MP and NonStop
SQL/MX 2
Collations 35, 13
Column names 9
COMMIT WORK statement 20
Compound
rowsets 3
statements 3
Constraints 10
CONTROL QUERY directives
migrating to NonStop SQL/MX 19
CONTROL TABLE directives, migrating to
NonStop SQL/MX 17
Controlled availability (CA) release 5
Cursors, updatable 46
D
Data control language (DCL) statements, migrat-
ing to NonStop SQL/MX 17
Data definition language (DDL) statements, mi-
grating to NonStop SQL/MX 14
Data Dictionary 5
Data manipulation language (DML) statements,
migrating to NonStop SQL/MX 21
Data mining 3
Data security language (DSL) statements, mi-
grating to NonStop SQL/MX 40
Data types
character string columns 9
date-time 35, 9
floating point 40, 9
interval 38, 9
VARCHAR 43
Database migration
assessing the current system 6
planning the new system 12
selecting data movement tools and methods
21
Database object
names 6
references 31
security 7
versioning 8
DataLoader/MX 22
Date-time host variables, differences between
SQL/MX Release 1.8 and SQL/MX Release 2.x
44
Date-time literals 36
DDL files
removing after fallback to NonStop SQL/MP
3
Decoupled range partitioning 11
Default compiler version 8
DEFINE names 32, 3
Descriptor area 48
Development environment, NonStop SQL/MX
54
Diagnostics area 52
Disk Space Analysis Program (DSAP) 2
Distributed database 7
Dynamic SQL, migrating to NonStop SQL/MX
47
E
EAP release
See Early adopter (EAP) release
Earliest supported
MXV 8
plan version 8, 10
schema version 8, 9
Earliest supported MXV 8
Early adopter (EAP) release 5
Early Product Delivery (EPD) 6
Embedded SQL/MP applications, migrating to
NonStop SQL/MX 6