SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

What’s New in This Manual
HP NonStop SQL/MX Reference Manual—544517-008
xxxiii
Changes to the H06.19/J06.08 Manual
Changes to the H06.19/J06.08 Manual
•
Updated the Product Release Version from SQL/MX 2.3.2 to SQL/MX 2.3.3.
•
Updated SERIALIZABLE or REPEATABLE READ on page 1-22.
•
Added MultiUnion operator on page 2-36 and its description on page 2-38.
•
Removed the example of GRANT that includes the domain name from Examples
of GRANT on page 2-162.
•
Removed the references to a RANDOM function.
•
Updated DEFAULT for Updatability on page 3-25.
•
Added an example of DISPLAY_EXPLAIN using the MultiUnion operator on page
4-24.
•
Updated the example of SHOWCONTROL to include the following CQDs:
°
CHECK_CONSTRAINT_PRUNING on page 4-69
°
MULTIUNION on page 4-70
°
UNION_TRANSITIVE_PREDICATES on page 4-70
•
Added an example of SHOWDDL on page 4-82.
•
Added an example of SHOWSHAPE using the MultiUnion operator on page 4-96.
•
Added FASTCOPY Utility on page 5-11.
•
Updated Exporting Metadata and Statistics of SQL/MX Objects on page 5-89.
•
Removed the term metadata and updated the title of the following topics:
°
Supported by mxexportddl
°
Not Supported by mxexportddl
°
Supported by mximportddl
°
Not Supported by mximportddl
•
Updated Examples of mxexportddl on page 5-91.
•
Updated Importing Metadata and Statistics of SQL/MX Objects on page 5-100.
•
Updated Examples of mximportddl on page 5-106.
•
Updated DEFAULT literal on page 7-2.
•
Updated number-bytes field of BLOCKSIZE file attribute on page 8-4.
•
Updated the result type of the following SQL/MX functions:
°
LTRIM on page 9-84
°
RTRIM on page 9-127