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

HP NonStop SQL/MX Database and Application Migration Guide—540435-005
Index-1
Index
A
Access options, STABLE access 10-25
Aggregate predicates 10-29
ANSI compliance 10-2, 11-2
Assistance 1-20
ASSOC2DS metadata table 6-4
Atomicity 7-3
Automatic recompilation, warnings 10-56
Auto-abort 10-20
B
BEGIN WORK statement 10-20
Business objectives, determining 1-9
C
CA release
See Controlled availability (CA) release
Capacity planning
NonStop SQL/MP to NonStop
SQL/MX 9-2
SQL/MX Release 1.8 to SQL/MX
Release 2.x 5-2
Carr Scott Software Inc. 1-7
CAST function
and descriptor area 10-49
data conversion 10-44
Catalogs, user 11-6
Character sets 10-34
Clustering keys 11-10
Coexistence, NonStop SQL/MP and
NonStop SQL/MX 1-3
Collations 10-35, 11-14
COLS metadata table 6-4
Column names 11-9
COMMIT WORK statement 10-20
Compatibility issues for releases 2-8
Compound
rowsets 10-3
Compound (continued)
statements 10-3
Constraints 11-11
CONTROL QUERY directives
changes in SQL/MX Release 2.x 7-7
migrating to NonStop SQL/MX 10-19
CONTROL TABLE directives, migrating to
NonStop SQL/MX 10-17
Controlled availability (CA) release 2-7
Cursors, updatable 10-46
D
Data control language (DCL) statements,
migrating to NonStop SQL/MX 10-17
Data definition language (DDL) statements,
migrating to NonStop SQL/MX 11-14
Data Dictionary 11-5
Data manipulation language (DML)
statements, migrating to NonStop
SQL/MX 10-21
Data mining 10-3
Data security language (DSL) statements,
migrating to NonStop SQL/MX 10-40
Data types
character string columns 11-10
date-time 10-35, 11-10
floating point 10-40, 11-10
interval 10-38, 11-10
VARCHAR 10-43
Database migration
assessing the current system 1-10
choosing phased versus rapid
migration 1-5
planning the new system 1-17
selecting data movement tools and
methods 11-22
Database object
names 11-6
references 10-31