SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-69
Exceptions to Conformance With Entry Level SQL
1992
ANSI/ISO SQL provides both statement atomicity (all changes made during a
multirecord operation are canceled if an error occurs during the operation) and
implicit transaction beginnings.
In NonStop SQL/MP, audited tables have equivalent protection for a TMF
transaction but not for a single statement. You must explicitly begin each
transaction within a program, and you must explicitly begin any multistatement
transactions entered through SQLCI.
NonStop SQL/MP protects audited tables by requiring DML statements within
programs to occur within explicitly defined transactions; however, NonStopSQL/MP
also allows you to create nonaudited tables that are not protected even within
transactions.

Updates
ANSI/ISO SQL allows a positioned UPDATE on any updateable cursor. NonStop
SQL/MP requires a FOR UPDATE clause on the UPDATE WHERE CURRENT
statement for a positioned UPDATE.

Other features
NonStop SQL/MP does not include these features:

Delimited identifiers

Explicit naming of select list elements

Module language

SQLSTATE status codes

Updateable primary keys

DECIMAL columns declared without explicit lengths

Language embeddings for Ada, FORTRAN, and PL/1