SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

What’s New in This Manual
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
4
New and Changed Information
New and Changed Information
Changes to 691117-001 manual:

Statements:

Updated REVOKE Statement on page 2-243.

Updated ALTER VIEW Statement on page 2-42.

Updated CREATE TABLE Statement on page 2-95.

Updated CREATE VIEW Statement on page 2-142 and CREATE TRIGGER
Statement on page 2-132.

Updated DELETE Statement on page 2-150.

Updated DROP SCHEMA Statement on page 2-166.

Updated INSERT Statement on page 2-217.

Updated UPDATE Statement on page 2-310.

Embedded-only SQL/MX statements:

GET DIAGNOSTICS Statement on page 3-55.

MXCI Commands

Updated SHOWDDL Command on page 4-82.

Added SHOWSTATS Command on page 4-110.

Utilities:

Added CLEANUP Operation on page 5-5.

Updated DOWNGRADE Utility on page 5-9.

Updated MODIFY Utility on page 5-79.

Updated FIXUP Operation on page 5-30.

Updated FIXRCB Operation on page 5-29.

Updated PURGEDATA Utility on page 5-130.

Updated UPGRADE Utility on page 5-137.

Updated VERIFY Operation on page 5-142.

Functions and Expressions:

DATE_ADD Function on page 9-44.

DATEADD Function on page 9-44.

DATE_SUB Function on page 9-48.