NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-69
NonStop SQL/MP Features From Intermediate Level
SQL 1992
SQL/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 the following 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
NonStop SQL/MP Features From Intermediate Level SQL 1992
NonStop SQL/MP includes the following 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