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-8
T
SQL/MX Release 1.8
definition of 1-2
initializing after fallback 8-7
required RVU 8-1
steps to migrate to SQL/MX Release
2.x 5-5
SQL/MX Release 1.8 applications
distributed databases 7-7
migrating 7-1/7-8
preparing to migrate to SQL/MX
Release 2.x 5-5
recompiling 7-7
SQL/MX Release 2.2, query plan
versioning 2-14
SQL/MX Release 2.x
character sets 10-34
corequisite independent products 5-4
definition of 1-2
fallback considerations 6-3
feature implementation 5-3
hardware requirements 5-1
metadata tables 6-3
operating system requirements 5-1
query optimization and statistics 7-7
software version identifiers 2-10
SQL/MX releases
availability 2-6
compatibility 2-8
delivery 2-7
G-series RVUs 2-2
H-series RVUs 2-3
interoperability 2-8
naming scheme 2-4
SQL/MX software components, version
identification 2-9
SQL/MX system software version
(MXV) 2-10
SQL/MX utilities 11-16
STABLE access
comparison of NonStop SQL/MP and
NonStop SQL/MX 10-25
STABLE access (continued)
description of 10-25
differences between SQL/MX Release
1.8 and SQL/MX Release 2.x 7-4
EXCLUSIVE MODE 10-26
READ COMMITTED 10-25
Statement-level atomicity 7-3
Statistics
SQLSA 10-53
updating 10-59, 11-26
Stored procedures in Java (SPJs) 10-4
String literal delimiters 10-33
System catalog 11-5
System modules, removing during
fallback 8-5
SYSTEM_DEFAULTS metadata table 6-3
T
Tables 11-8
Testing, guidelines 1-19
TEXT metadata table 6-4
Third-party data replication tools 11-26
Transaction control statements, migrating to
NonStop SQL/MX 10-19
Transaction management
auto abort 10-20
implicit transactions 10-20
inherited transactions 10-20
T-number 2-5
U
Unique constraints 11-11
Updatable cursors 10-46
UPDATE statements, migrating to NonStop
SQL/MX 10-24
UPDATE STATISTICS command 10-59,
11-26
UPD_ABORT_ON_ERROR default
attribute 7-3
Upgrade
definition of 1-1