SQL/MX 2.x Reference Manual (H06.04+)

What’s New in This Manual
HP NonStop SQL/MX Reference Manual—540440-003
xxxiii
Changes to the H06.05 Manual
Changes to the H06.05 Manual
Section New or Changed Information
1 Introduction
Updated information in SKIP CONFLICT on
page 1-8.
2 SQL/MX Statements
Added new Examples of CREATE TRIGGER on
page 2-101.
Changed information on rowsets in DELETE
Statement on page 2-109 and UPDATE Statement
on page 2-226.
Updated UPDATE STATISTICS Statement on
page 2-239.
3 Embedded-Only SQL/MX
Statements
Updated ALLOCATE CURSOR Statement on
page 3-3.
Updated Statement Items of GET DIAGNOSTICS
on
page 3-56.
4 MXCI Commands
Updated DISPLAY USE OF Command on page 4-9.
Updated SHOWLABEL, DETAIL Output on
page 4-81.
5 SQL/MX Utilities
Updated import Utility on page 5-21.
Updated MODIFY Utility on page 5-47.
6 SQL/MX Language Elements
Updated Restrictions on Using Character Set Data
on page 6-3.
Updated Numeric Data Types
on page 6-17 to
discuss floating-point data.
Updated Partitions on page 6-79 with more
information on hash partitioned tables.
Updated SQL/MP Views on page 6-109.
8 SQL/MX File Attributes
Updated MAXEXTENTS on page 8-7.
9 SQL/MX Functions and
Expressions
New function HASHPARTFUNC Function on
page 9-61.
10 Metadata Tables
Updated ROUTINES Table on page 10-23.
Added new defaults in
HIST_SECURITY_WARNINGS
on page 10-45,
DDL_DEFAULT_ LOCATIONS on page 10-51, and
INTERACTIVE_ACCESS on page 10-65.
Default JOINCARD_LOWBOUND_PERCENT is now
HIST_JOIN_CARD_ LOWBOUND on page 10-42.