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-5
FILEINFO 11
INVOKE 12
LOAD 12
RESET REPORT 13
SHOWCONTROL 13
VERIFY 14
SQLCI scripts 8
SQLCODE mappings 49
SQLDA 47
SQLSA 53
SQLSTATE mappings 49
STABLE access
comparison of NonStop SQL/MP and Non-
Stop SQL/MX 25
description of 25
EXCLUSIVE MODE 26
READ COMMITTED 25
Statistics
SQLSA 53
updating 59, 25
Stored procedures in Java (SPJs) 4
String literal delimiters 33
System catalog 5
T
Tables 8
Testing, guidelines 14
Third-party data replication tools 25
T-number 4
Transaction control statements, migrating to
NonStop SQL/MX 19
Transaction management
auto abort 20
implicit transactions 20
inherited transactions 20
U
Unique constraints 10
Updatable cursors 46
UPDATE statements, migrating to NonStop
SQL/MX 24
UPDATE STATISTICS command 59, 25
Upserts 20
Utilities 16
V
VARCHAR data type 43
Version
definition of 1
identification 7
modules 11
query execution plan 10
schema 9
SQL/MX database object 9
SQL/MX software 8
Versioned persistent entities 7
Versioned software components 7
Versioning
SQL/MX software components 7
Views 13
VPROC information
date 4
final build date 4
product version identifier 4
SPR identifier 4
SQL/MX release number 4
W
WHENEVER declarative 52