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-7
S
SQLCI commands, migrating (continued)
DISPLAY STATISTICS 10-10
DISPLAY USE OF 10-10
DROP SYSTEM CATALOG 10-11
EXPLAIN 10-11
FILEINFO 10-11
INVOKE 10-12
LOAD 10-12
RESET REPORT 10-13
SHOWCONTROL 10-14
VERIFY 10-15
SQLCI scripts 10-8
SQLCODE mappings 10-49
SQLDA 10-47
SQLJ applications, converting to
JDBC/MX 7-8
SQLSA 10-53
SQLSTATE mappings 10-49
SQL/MP
See NonStop SQL/MP
SQL/MP applications
converting to SQL/MX
applications 10-1
/10-61
definition of 1-1
modifying source code 10-16
preparing to migrate to NonStop
SQL/MX 9-5
steps for converting to NonStop
SQL/MX 10-15
types of 10-6
SQL/MP database
loading data into an SQL/MX
database 11-22
steps for converting to NonStop
SQL/MX 11-21
SQL/MP database objects
converting to SQL/MX database
objects 11-1
/11-26
preparing to migrate to NonStop
SQL/MX 9-5
SQL/MP metadata, migrating 6-1/6-15
destination metadata tables 6-3
fallback considerations 6-3
system requirements 6-2
SQL/MP Report Writer, migrating to
SQL/MX Report Writer 10-15
SQL/MP stored text 10-31
SQL/MP syntax, converting to NonStop
SQL/MX 10-16
SQL/MP tables, nonaudited 10-21
SQL/MX
See NonStop SQL/MX
SQL/MX applications
compiling 10-54
definition of 1-1
moving to production 10-60
SQL/MX database objects
dropping after fallback 8-6
dropping during fallback to SQL/MX
Release 1.8 8-5
managing versions 2-13
versions 2-11
SQL/MX database, comparison with
SQL/MP database 11-4
/11-14
SQL/MX DDL license 9-4
SQL/MX DDL statements 11-14
SQL/MX executor 10-4
SQL/MX metadata tables
ASSOC2DS 6-4
COLS 6-4
DATASOURCES 6-4
ENVIRONMENTVALUES 6-4
MP_PARTITIONS 6-3
NAME2ID 6-4
OBJECTS 6-3, 6-4
RESOURCEPOLICIES 6-4
ROUTINES 6-4
SYSTEM_DEFAULTS 6-3
TEXT 6-4
SQL/MX optimizer 10-4