NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-70
NonStop SQL/MP Features From Full Level SQL
1992
•
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 the following:
°
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.
NonStop SQL/MP has access options that are similar to ANSI/ISO Isolation Levels.
You can set the access option for an individual DML statement (but not for an entire
transaction) to BROWSE, STABLE, or REPEATABLE. The default, STABLE, is
equivalent to the ANSI/ISO Isolation Level READ COMMITTED.
Note that what NonStop SQL/MP calls access options are not related to the
ANSI/ISO Access Mode for a transaction. NonStop SQL/MP has no equivalent for
Access Mode.
NonStop SQL/MP Features From Full Level SQL 1992
NonStop SQL/MP includes the following features from Full 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 extensions (arbitrary precision for seconds)
•
CREATE COLLATION and DROP COLLATION statements
•
The ability to add and drop single-table assertions
(ANSI/ISO SQL provides CREATE ASSERTION and DROP ASSERTION
statements. NonStop SQL/MP provides a similar capability for single-table
assertions with CREATE CONSTRAINT and DROP CONSTRAINT statements.)
NonStop SQL/MP Extensions to SQL 1992
NonStop SQL/MP provides the following extensions to ANSI/ISO SQL: