Neoview SQL Reference Manual (R2.5)

Level of SupportID, Feature
Neoview SQL fully supports these subfeatures:
• 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 TIMESTAMP 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))
F051 Basic date and
time
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-01 Simple CASE
• F261-02 Searched CASE
Neoview SQL does not support these subfeatures:
• F261-03 NULLIF
• F261-04 COALESCE
F261 CASE
expressions
Neoview SQL partially supports these subfeatures:
• 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.)
• F311-03 CREATE VIEW (without WITH CHECK OPTION and without Feature F081
“UNION and EXCEPT in views” Neoview SQL views cannot refer to tables created in the
same CREATE SCHEMA)
• F311-04 CREATE VIEW: WITH CHECK OPTION (Without support for Feature F081
“UNION and EXCEPT in views” Neoview SQL views cannot refer to tables created in the
same CREATE SCHEMA)
• F311-05 GRANT statement (Neoview SQL does not support creation of a schema and its
contents in a single statement, including performing grant operations. Objects must be
created in a particular order, dependent objects first.)
F311 Schema
definition statement
Neoview SQL fully supports this subfeature:
• T321-04 CALL statement
T321 Basic
SQL-invoked
routines
Neoview SQL does not support these Core SQL:1999 features:
FeatureID
Updatable queries with subqueriesE153
Basic information schemaF021
Features and conformance viewsF501
Basic flaggingF812
Distinct data typesS011
Neoview SQL supports embedded language. Neoview SQL does not support E182, module
language. Even though this feature is listed in Table 31 in the standard, Core SQL:1999 allows a
528 Standard SQL and Neoview SQL