SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-71
SQL/MP Features From Full Level SQL 1992
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 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.
SQL/MP Features From Full Level SQL 1992
NonStop SQL/MP includes these 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.)
SQL/MP Extensions to SQL 1992
NonStop SQL/MP provides these extensions to ANSI/ISO SQL:

Additional data types:

LARGEINT (64-bit integers) and PIC data types

UNSIGNED/SIGNED option for numeric data types

Additional table features:

Ascending or descending order for user-defined primary keys

System-generated primary keys

Clustering keys

Distributed tables

System default values for columns

Key-sequenced, entry-sequenced, and relative file types

Partitioned tables

Nonaudited tables

Other Guardian file attributes for tables

Additional DDL statements: