Neoview SQL Reference Manual (R2.4 SP2)

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
514 Standard SQL and Neoview SQL