SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

What’s New in This Manual
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
vi
Changes to 691117-001 manual:
°
Updated DROP SCHEMA Statement on page 2-182.
°
Updated INSERT Statement on page 2-251.
°
Updated UPDATE Statement on page 2-384.
•
Embedded-only SQL/MX statements:
°
GET DIAGNOSTICS Statement on page 3-55.
•
MXCI Commands
°
Updated SHOWDDL Command on page 4-83.
°
Added SHOWSTATS Command on page 4-112.
•
Utilities:
°
Added CLEANUP Operation on page 5-3.
°
Updated DOWNGRADE Utility on page 2-174.
°
Updated MODIFY Utility on page 2-270.
°
Updated FIXUP Operation on page 5-8.
°
Updated FIXRCB Operation on page 5-7.
°
Updated PURGEDATA Utility on page 2-306.
°
Updated UPGRADE Utility on page 2-411.
°
Updated VERIFY Operation on page 5-79.
•
Functions and Expressions:
°
DATE_ADD Function on page 8-44.
°
DATEADD Function on page 8-44.
°
DATE_SUB Function on page 8-48.
°
DATEDIFF Function on page 8-46.
•
Metadata Tables:
°
Updated the SCHEMATA Table on page 10-10
°
Updated the OBJECTS Table on page 10-22.
°
Updated SEQUENCE_GENERATORS Table on page 10-28.
°
Updated VWS Table on page 10-35.
°
Added the CQD DDL_VIEW_SIMILARITY_CHECK to Query Optimization and
Performance on page 10-66