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-2
Embedded SQL/MP constructs, migrating to
NonStop SQL/MX 41
Embedded SQL/MP statements, converting to
NonStop SQL/MX 45
Embedded SQL/MX applications
managing modules 57
Error handling, differences between NonStop
SQL/MP and NonStop SQL/MX 49
ETK
See HP Enterprise Toolkit (ETK)
EXCLUSIVE MODE 26
EXECUTE statement 46
Executor 4
F
Fallback
definition of 1
falling back to NonStop SQL/MP 1–3
planning 3
procedure 1
FETCH statement 47
File attributes 8
Functions
migrating to NonStop SQL/MX 26
SETSCALE 42
G
GA release
See General availability (GA) release
GCSC
See Global Customer Support Center (GC-
SC)
General availability (GA) release 5
GET DIAGNOSTICS statement
C example 53
description of 53
Global Customer Support Center (GCSC) 15
GRANT statement 7
Guardian applications, converting to OSS 54
H
Hardware
migrating to 4
Hash partitioning 11
HASHPARTFUNC function 22
Host variable declarations 42
HP Enterprise Toolkit (ETK) 7
I
IEEE floating point 1
Implicit transactions 20
import, DataLoader/MX use of 22
Incremental releases 3
Independent products
migrating to NonStop SQL/MX 4
Indexes 11
Indicator variables 44
Inherited transactions 20
Initial product version (PV) 5
INSERT statements, migrating to NonStop
SQL/MX 22
INSERT-SELECT statement 22
Interoperability 7
Interval data type 38
Interval literals 40
INVALIDATE option, indexes 12
INVOKE directive
differences between NonStop SQL/MP and
NonStop SQL/MX 43
Isolation level
differences 25
STABLE access 25
statement level 24
transaction level 24
J
JDBC/MP applications, migrating to NonStop
SQL/MX 8
Joins, types of 23
L
LIKE predicate 30
Locks, releasing 46
M
Maintenance releases 4
Major releases 3
Measure 14
Migration
assistance 15
choosing applications and database objects
10
definition of 1
guidelines for conducting 14
initial planning 4
NonStop hardware platform 4
planning for
NonStop SQL/MP to NonStop SQL/MX
1–5
terminology 1
tools for moving data 21