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

What’s New in This Manual
HP NonStop SQL/MX Reference Manual—544517-008
xxxii
New and Changed Information
New and Changed Information
Changes to the H06.20/J06.09 manual:
•
Added the CASCADE, SET NULL, and SET DEFAULT referential constraint
actions and considerations in the following SQL/MX statements:
°
ALTER TABLE statement on pages 2-11, 2-16, and 2-22.
°
CREATE TABLE statement on pages 2-78, 2-84, and 2-95.
•
Updated the description of file-name under the CREATE VIEW statement on
page 2-111.
•
Added EXPLAIN Statement on page 2-143.
•
Removed the Display_Explain command.
•
Added GTACL Command on page 4-31.
•
Updated the syntax and the description of the LOG command on page 4-36.
•
Updated the referential integrity considerations for the following:
°
Considerations for DUP on page 5-8.
°
Considerations for mxexportddl on page 5-91
°
Considerations for mximportddl on page 5-105
°
Considerations for PURGEDATA on page 5-113
•
Added the COMPILERCONTROLS function under Table-Valued Stored Functions
on page 9-9.
•
Added COMPILERCONTROLS Function on page 9-28.
•
Updated the description of SKIP_UNAVAILABLE_PARTITION on page 10-49.
•
Updated the value range of the following attributes:
°
DP2_CACHE_4096_BLOCKS on page 10-58
°
NUMBER_OF_USERS on page 10-62
°
DEF_MAX_HISTORY_ ROWS on page 10-68
•
Updated the description of INFER_CHARSET on page 10-60.
•
Updated the description of the MEMORY_USAGE_SAFETY_NET attribute on
page 10-61.
•
Added the following commands under A, Quick Reference:
°
EXPLAIN statement on page A-3
°
GTACL command on page A-3