Neoview SQL Reference Manual (R2.2)

Neoview SQL Compliance
The ANSI and ISO SQL standards require conformance claims to state the type of conformance
and the implemented facilities. Neoview SQL products provide full or partial conformance. This
table lists the Core SQL:1999 features for which Neoview SQL offers full conformance:
FeatureID
Numeric data typesE011
Character data typesE021
IdentifiersE031
Basic query specificationE051
Basic predicates and search conditionsE061
Basic privilegesE081
Set functionsE091
Basic data manipulationE101
Single row SELECT statementE111
Null value support (nulls in lieu of values)E131
Transaction supportE151
Basic SET TRANSACTION statementE152
SQLSTATE supportE171
Basic schema manipulationF031
Basic joined tableF041
Grouped operationsF131
Multiple module supportF181
CAST functionF201
Scalar subquery valuesF471
Expanded NULL predicateF481
This table lists the Core SQL:1999 features for which Neoview SQL offers partial support:
Level of SupportID, Feature
Neoview SQL fully supports this
subfeature:
E071 Basic query expressions
E071-02 UNION ALL table operator
Neoview SQL partially supports these
subfeatures:
E071-01 UNION [DISTINCT] table
operator (Neoview SQL does not
support explicitly specifying
DISTINCT)
E071-05 Columns combined by table
operators need not have exactly the
same type (Neoview SQL has rules for
determining result types that are not
identical to SQL '99 rules)
E071-06 table operators in subqueries
(Neoview SQL allows only UNION in
subqueries)
Neoview SQL does not support this
subfeature:
444 Standard SQL and Neoview SQL