SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

Converting SQL/MP Applications to SQL/MX
Applications
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
10-57
Similarity Checks and Automatic Recompilation of
Embedded SQL/MX Applications
Number of indexes—more indexes at run time than
at compile time
Yes Yes for SELECT
No for INSERT,
UPDATE,
DELETE
Number of indexes—fewer indexes at run time than
at compile time
Yes if index is
not used by plan
Yes for SELECT
if index not used
by plan
No for INSERT,
UPDATE,
DELETE
Unique index present both at compile time and at run
time
Yes No
Key tags (or values) for indexes Yes No for SQL/MP
indexes
N.A. for SQL/MX
indexes
Creation and redefinition timestamp Yes Yes
Audit attribute Yes with minor
exception
No for SQL/MP
tables
N.A. for SQL/MX
tables
Attributes:
ALLOCATE
AUDITCOMPRESS
BUFFERED
CLEARONPURGE
EXTENT (primary and secondary)
LOCKLENGTH
MAXEXTENTS
NOPURGEUNTIL
OWNER
SECURE
SERIALWRITES
TABLECODE
VERIFIEDWRITES
Yes Yes
Statistics on the table Yes Yes
Column headings Yes Yes
Table 10-15. Comparison of Similarity Checks Between NonStop SQL/MP and
NonStop SQL/MX (page 2 of 3)
Difference Between Compile Time and Run Time
Similarity check
passes in
NonStop
SQL/MP?
Similarity check
passes in
NonStop
SQL/MX?