SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

What’s New in This Manual
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
xxxvii
New and Changed Information
°
Updated EXPLAIN Statement on page 2-176.
°
Added new content in Examples of EXPLAIN on page 2-179.
°
Updated INSERT Statement on page 2-209.
°
Updated SELECT Statement on page 2-242.
°
Updated Considerations for GROUP BY on page 2-263.
•
Utilities:
°
Updated DUP Utility on page 5-8.
°
Updated FASTCOPY Utility on page 5-15.
°
Added Renaming Guardian location of partitions of tables or indexes on
page 5-87.
°
Updated Rename under MODIFY and TMF on page 5-90.
°
Added MODIFY and RDF on page 5-92.
°
Added examples for rename under Examples of MODIFY on page 5-94.
°
Updated mxexportddl Utility on page 5-96.
°
Updated MXGNAMES Utility on page 5-100.
°
Added new content in Examples of MXGNAMES on page 5-102.
°
Updated mximportddl Utility on page 5-108.
•
Functions and Expressions:
°
COALESCE Function on page 9-27.
°
DECODE Function on page 9-50.
°
Updated Result of the EXPLAIN Function on page 9-61.
°
LNNVL Function on page 9-84.
°
NVL Function on page 9-118.
°
NVL2 Function on page 9-120.
°
TO_CHAR(<NUMERIC>) Function on page 9-176.
°
TO_CHAR(<DATETIME>) Function on page 9-180.
°
Updated LTRIM Function on page 9-97.
°
Updated RTRIM Function on page 9-147.
°
Updated TRIM Function on page 9-187.
•
Metadata Tables:
°
Updated the COLS Table on page 10-15.