MP Users

DML Features

HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003

3-8

Interval Literals

As in NonStop SQL/MP, an SQL/MX interval literal is either year-month or day-time. If

you are using SQL/MX DML statements with SQL/MP tables, NonStop SQL/MX

recognizes fields created with the FRACTION keyword and maps them directly to the

fractional precision of the SECOND field.

These are INTERVAL literals:

INTERVAL '7' DAY

INTERVAL '2-7' YEAR TO MONTH

INTERVAL '5:2:15:36.33' DAY TO SECOND(2)

An SQL/MP interval with a literal of DAY TO FRACTION(2) becomes in SQL/MX DAY

TO SECOND(2).

Expressions and Functions

NonStop SQL/MP supports three types of expressions: value expressions, row-value

constructors, and query expressions. NonStop SQL/MX supports SQL:1999 versions of

value expressions, row-value constructors, and query expressions. For a complete list

of SQL/MX expressions and functions, see the SQL/MX Reference Manual.

Table 3-2 lists only the SQL/MP functions that are obsolete or changed in NonStop

SQL/MX:

INTERVAL start to FRACTION(n) Yes INTERVAL start to

SECOND(n)

All other INTERVAL start-end combinations Yes Same as in NonStop

SQL/MP

*Limited support as dummy values in SELECT

statements only

Table 3-1. Support For NonStop SQL/MP DATETIME Literals in NonStop

SQL/MX (page 3 of 3)

NonStop SQL/MP DATETIME Type

Supported

in NonStop

SQL/MX Maps To ANSI Type