Neoview SQL Reference Manual (R2.3)

Level of SupportID, Feature
E071-03 EXCEPT [DISTINCT] table
operator
Neoview SQL fully supports these
subfeatures:
E121 Basic cursor support
E121-01 DECLARE CURSOR
E121-02 ORDER BY columns need not
be in select list
E121-06 Positioned UPDATE statement
E121-07 Positioned DELETE statement
E121-08 CLOSE statement
Neoview SQL partially supports these
subfeatures:
E121-04 OPEN statement (Neoview
SQL syntax does not match that of SQL
'99)
E121-10 FETCH statement, implicit
NEXT (Neoview SQL syntax does not
match that of SQL '99)
E121-17 WITH HOLD cursors
(supported only for SELECT statements
that use stream access mode or an
embedded UPDATE or embedded
DELETE)
Neoview SQL does not support this
subfeature:
E121-03 Value expressions in ORDER
BY clause
Neoview SQL fully supports these
subfeatures:
E141 Basic integrity constraints
E141-01 NOT NULL constraints
E141-03 PRIMARY KEY constraints
E141-06 CHECK constraints
Neoview SQL partially supports these
subfeatures
E141-07 Column defaults (Neoview
SQL specifies a subset of datetime
value functions that Core '99
allows to be specified. Neoview SQL
does not enforce the conformance rule
that “Without Feature F411 “Time zone
specification”, CURRENT_TIME and
CURRENT_TIMESTAMP shall not be
specified.”)
Neoview SQL does not support these
subfeatures:
E141-08 NOT NULL inferred on
PRIMARY KEY
E141-10 Names in a foreign key can be
specified in any order (The column in
the column list associated with
REFERENCES must be in the same
order as the column in the column list
associated with FOREIGN KEY)
Neoview SQL Compliance 467