SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-70
SQL/MP Features From Intermediate Level SQL
1992
SQL/MP Features From Intermediate Level SQL 1992
NonStop SQL/MP includes these features from Intermediate Level ANSI/ISO SQL,
although the specific implementation of the features does not always conform exactly
to the implementation described in the ANSI/ISO standard:

DATETIME, NATIONAL CHARACTER, and VARCHAR data types

The ability to add and drop constraints
(ANSI/ISO SQL provides ALTER TABLE ADD CONSTRAINT and ALTER TABLE
DROP CONSTRAINT statements. NonStop SQL/MP provides a similar capability
with the CREATE CONSTRAINT and DROP CONSTRAINT statements.)

The CURRENT_TIMESTAMP function and the functionality of the
CURRENT_DATE, CURRENT_TIME, and EXTRACT functions
(NonStop SQL/MP includes a CURRENT function and date-time field specifications
in expressions that provide functionality equivalent to CURRENT_DATE,
CURRENT_TIME, and EXTRACT.)

The CAST function for parameters

The ALTER TABLE ADD COLUMN statement

The DROP TABLE and DROP VIEW statements

Case-insensitive identifiers

INNER JOIN and LEFT OUTER JOIN operators
(NonStop SQL/MP uses the keywords LEFT JOIN instead of LEFT OUTER JOIN
for this operator.)

Multiple built-in character sets (partial support only)

Dynamic SQL, including:

Use of host variables for statement and cursor names

PREPARE, EXECUTE, and EXECUTE IMMEDIATE statements

DESCRIBE and DESCRIBE INPUT statements

USING DESCRIPTOR and USING clauses on OPEN CURSOR

RETURNING clause on the EXECUTE and INSERT

Subqueries in comparison predicates that have GROUP BY and HAVING clauses
or FROM clause references to grouped views

UNION and UNION ALL in view definitions and subqueries

ANSI/ISO SQL allows you to set the Isolation Level for a transaction to READ
UNCOMMITTED, READ COMMITTED, REPEATABLE READ, or SERIALIZABLE.
The default is SERIALIZABLE.