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

What’s New in This Manual
HP NonStop SQL/MX Reference Manual—544517-008
xxxv
Changes to the H06.16/J06.05 Manual
Changes to the H06.16/J06.05 Manual
•
Updated the Product Release Version from SQL/MX 2.3.1 to SQL/MX 2.3.2.
•
Added the supported release statement for Result Set Support for Stored
Procedures in Java on page 2-5.
•
Updated the description of access-path under CONTROL QUERY SHAPE
Statement on page 2-41.
•
Updated the DYNAMIC RESULT SETS clause under CREATE PROCEDURE
Statement and its description on page 2-66.
•
Added two examples under Examples of CREATE PROCEDURE on page 2-68.
•
Added the clause sample-table-clause under UPDATE STATISTICS on page
2-262 and its description on page 2-266.
•
Added Using Sample Table with Partitions on page 2-269.
•
Added two examples under Examples of UPDATE STATISTICS on page 2-271.
•
Updated the description of SQL/MP Conversion Issues on page 4-74.
•
Updated the example of SHOWDDL on an SQL/MP table on page 4-78.
•
Added example under Examples of SHOWDDL on page 4-82.
•
Added new syntax and description for Partition Name support under:
°
Reuse an Existing Partition of a Range Partitioned Table on page 5-68
°
Manage Partitions of Range Partitioned Tables and Indexes on page 5-71
°
Manage Partitions of Hash Partitioned Tables and Indexes on page 5-76
•
Added new syntax for Partition Name support under Manage System-Clustered
Tables on page 5-82.
•
Added example under Examples of EXPLAIN on page 9-61.
•
Updated the description of 11 MAX_RESULTS on page 10-23.
•
Updated the description of TEXT Table on page 10-25.
•
Added the attribute ALLOW_DP2_ROW_SAMPLING and its description on page
10-57.
•
Added the attribute INFER_CHARSET and its description on page 10-60.
Changes to the H06.15/J06.04 Manual
•
Supported release statements have been updated to include J-series RVUs.
•
Updated Isolation Levels of Transactions and Access Options of Statements on
page 2-118.