Neoview SQL Reference Manual (R2.3)

Level of SupportID, Feature
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.)
Neoview SQL fully supports this
subfeature:
T321 Basic SQL-invoked routines
T321-04 CALL statement
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
choice between module language and embedded language. Module language and embedded
language are identical in capability. They differ only in how SQL statements are associated with
the host programming language.
Neoview SQL Extensions to Standard SQL
Neoview SQL provides many features that enhance or supplement the functionality of standard
SQL. In your Neoview SQL applications, you can use these extensions just as you can use Core
SQL:1999. This table shows the Non-Core extensions that Neoview SQL supports:
FeatureID
Direct SQLB021
Basic dynamic SQLB031
Extended dynamic SQLB032
Isolation levels other than SERIALIZABLEF111
Basic diagnostics managementF121
Multiple schemas per userF171
INSERT statement: DEFAULT VALUES clauseF222
LIKE enhancementsF281
Neoview SQL Extensions to Standard SQL 469