Neoview SQL Reference Manual (R2.2)

Level of SupportID, Feature
The interface does not properly
process SQL comments when they are
issued from the Manager
E161 SQL comments using leading
double minus
Neoview SQL fully supports these
subfeatures:
F051 Basic date and time
F051-01 DATE data type (and literal)
F051-02 TIME data type (and literal)
with fractional seconds precision of at
least 0
F051-03 TIMESTAMP data type (and
literal) with fractional seconds
precision of at least 0 and 6
F051-04 Comparison predicate for
DATE, TIME, and TIME-STAMP data
types
F051-05 Explicit CAST between
datetime types and character types
F051-06 CURRENT_DATE
Neoview SQL does not support these
subfeatures
F051-07 LOCALTIME (equivalent to
CAST (CURRENT_TIME AS TIME
WITHOUT TIME ZONE))
F051-08 LOCALTIMESTAMP
(equivalent to
CAST(CURRENT_TIMESTAMP AS
TIMESTAMP WITHOUT TIME
ZONE))
Neoview SQL supports UNION but
not EXCEPT in views
F081 UNION and EXCEPT in views
Neoview SQL supports use of
DEFAULT in INSERT, but not in
UPDATE
F221 Explicit defaults
Neoview SQL supports these
subfeatures:
F261 CASE expressions
F261-01 Simple CASE
F261-02 Searched CASE
Neoview SQL does not support these
subfeatures:
Neoview SQL partially supports these
subfeatures:
F311 Schema definition statement
F311-01 CREATE SCHEMA (Neoview
SQL does not support creation of a
schema and its contents in a single
statement. Objects must be created in
a particular order, dependent objects
first.)
F311-02 CREATE TABLE for persistent
base tables (Neoview SQL does not
support creation of a schema and its
contents in a single statement. Objects
must be created in a particular order,
dependent objects first.)
446 Standard SQL and Neoview SQL