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-6
Q
PROCS metadata table, migrating 6-11
Product version identifiers 2-6
Product version update (PVU) 2-6
Program invalidation 10-55
Protection views 11-13
PROTOTYPE host variables 10-32
Publish/subscribe 10-3
PV
See Initial product version (PV)
PVU
See Product version update (PVU)
Q
Queries, multinode 5-5, 9-4
Query execution plans
displaying 10-59
forcing 10-59
optimizing performance 10-59
Query plan versioning
description of 2-12
managing 2-14
SQL/MX Releases 2.0 through
2.3.4 2-14
R
Rapid migration 1-5
READ UNCOMMITTED access, compared
to BROWSE access 10-25
Referential integrity constraints 11-11
Release version updates (RVUs) 2-7
Releases
compatibility issues 2-8
definition of 1-1
REPEATABLE access 10-25
Reserved words 10-32
RESOURCEPOLICIES metadata table 6-4
RETURN LASTSYSKEY clause 10-22
REVOKE statement 11-7
ROLLBACK WORK statement 10-20
ROUTINES metadata table 6-4
Rowsets, compound 10-3
Row-value constructors 10-30, 10-60
RVU, loading after fallback 8-5
S
Safeguard security management
facility 11-7
Scalability 10-5
Schemas
comparison between NonStop SQL/MP
and NonStop SQL/MX 11-6
version 2-10, 2-11
Scout for NonStop Servers 2-7
SDI
See NonStop Solutions Development
and Implementation (SDI)
SELECT statements
migrating to NonStop SQL/MX 10-23
placement of GROUP BY clause 10-24
table references 10-23
SERIALIZABLE access 10-25
SETSCALE function 10-42
Shorthand views 11-13
Similarity checks, differences between
NonStop SQL/MP and NonStop
SQL/MX 10-55
/10-58
Site update tape (SUT) 2-7
Software Product Revisions (SPRs) 2-7
Software version identifiers 2-10
Software versioning 2-9
SPJs
See Stored procedures in Java (SPJs)
SPRs
fallback 5-3
identifiers 2-6
SQL functions, migrating to NonStop
SQL/MX 10-26
SQLCA 10-53
SQLCI commands, migrating
compared with MXCI commands 10-9
CREATE SYSTEM CATALOG 10-10