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-4
REVOKE statement 7
ROLLBACK WORK statement 20
Rowsets, compound 3
Row-value constructors 30, 60
S
Safeguard security management facility 7
Scalability 5
Schemas
comparison between NonStop SQL/MP and
NonStop SQL/MX 5
version 8, 9
Scout for NonStop Servers 6
SDI
See NonStop Solutions Development and Im-
plementation (SDI)
SELECT statements
migrating to NonStop SQL/MX 23
placement of GROUP BY clause 24
table references 23
SERIALIZABLE access 25
SETSCALE function 42
Shorthand views 13
Similarity checks, differences between NonStop
SQL/MP and NonStop SQL/MX 55–57
Site update tape (SUT) 6
Software Product Revisions (SPRs) 6
Software version identifiers 8
Software versioning 7
SPJs
See Stored procedures in Java (SPJs)
SPRs
identifiers 5
SQL functions, migrating to NonStop SQL/MX
26
SQL/MP
See NonStop SQL/MP
SQL/MP applications
converting to SQL/MX applications 1–61
definition of 1
modifying source code 16
preparing to migrate to NonStop SQL/MX 4
steps for converting to NonStop SQL/MX 15
types of 6
SQL/MP database
loading data into an SQL/MX database 21
steps for converting to NonStop SQL/MX 20
SQL/MP database objects
converting to SQL/MX database objects 1–
25
preparing to migrate to NonStop SQL/MX 4
SQL/MP Report Writer, migrating to SQL/MX
Report Writer 14
SQL/MP stored text 31
SQL/MP syntax, converting to NonStop
SQL/MX 16
SQL/MP tables, nonaudited 21
SQL/MX
See NonStop SQL/MX
SQL/MX applications
compiling 53
definition of 2
moving to production 60
SQL/MX database objects
versions 8
SQL/MX database, comparison with SQL/MP
database 4–13
SQL/MX DDL license 4
SQL/MX DDL statements 14
SQL/MX executor 4
SQL/MX optimizer 4
SQL/MX Release 1.8
definition of 2
SQL/MX Release 2.x
character sets 34
definition of 2
software version identifiers 8
SQL/MX releases
availability 5
delivery 6
H-series RVUs 2
interoperability 7
naming scheme 3
SQL/MX software components, version identifi-
cation 7
SQL/MX system software version (MXV) 8
SQL/MX utilities 16
SQLCA 52
SQLCI commands, migrating
compared with MXCI commands 9
CREATE SYSTEM CATALOG 10
DISPLAY STATISTICS 10
DISPLAY USE OF 10
DROP SYSTEM CATALOG 11
EXPLAIN 11