SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

What’s New in This Manual
HP NonStop SQL/MX Reference Manual—640322-001
xxxiv
New and Changed Information
New and Changed Information
Changes to the 640322-001 manual:
•
Updated the description of Begin and End a Transaction on page 2-31.
•
Updated the maximum combined length of the columns for the following:
°
UNIQUE contraint on page 2-81
°
PRIMARY KEY constraint on page 2-82
°
REFERENCES contraint on page 2-83
•
Added Table 2-1, Maximum Key Sizes Available, on page 2-83.
•
Updated the description of key-column-list on page 2-86.
•
Added Table 2-2, Maximum Row Sizes Available, on page 2-94.
•
Updated the description of Creating Partitions Automatically on page 2-94.
•
Updated the Partitioning Columns section on 2-96.
•
Added note for triggers under:
°
Restrictions on Triggers section on page 2-106
°
Triggers on page 6-112
•
Updated Triggers and Primary Keys on page 2-107.
•
Added SELECT ROW COUNT Statement on page 2-231.
•
Removed the following entries from Table 3-2, Descriptor Area Data Type
Declarations, on page 3-51:
°
140 _SQLDT_REAL
°
140 _SQLDT_TDM_REAL
°
141 _SQLDT_DOUBLE
°
141 _SQLDT_TDM_DOUBLE
•
Added the following commands:
°
GET NAMES OF RELATED NODES Command on page 4-34
°
GET NAMES OF RELATED SCHEMAS Command on page 4-35
°
GET NAMES OF RELATED CATALOGS on page 4-36
°
GET VERSION OF SYSTEM on page 4-37
°
GET VERSION OF SCHEMA Command on page 4-38
°
GET VERSION OF SYSTEM SCHEMA Command on page 4-39