Neoview SQL Reference Manual (R2.4 SP2)
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-02 UNION ALL table operator
E071 Basic query
expressions
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:
• E071-03 EXCEPT [DISTINCT] table operator
Neoview SQL fully supports these subfeatures:
• E121-01 DECLARE CURSOR
• E121-02 ORDER BY columns need not be in select list
• E121-06 Positioned UPDATE statement
• E121-07 Positioned DELETE statement
• E121-08 CLOSE statement
• E121-03 Value expressions in ORDER BY clause
Neoview SQL partially supports these subfeatures:
• E121-04 OPEN statement (Neoview SQL syntax does not match that of SQL '99)
• E121-10 FETCH statement, implicit NEXT (Neoview SQL syntax does not match that of
SQL '99)
• E121-17 WITH HOLD cursors (supported only for SELECT statements that use stream
access mode or an embedded UPDATE or embedded DELETE)
E121 Basic cursor
support
Neoview SQL fully supports these subfeatures:
• E141-01 NOT NULL constraints
• E141-03 PRIMARY KEY constraints
• E141-06 CHECK constraints
Neoview SQL partially supports this subfeature:
• E141-07 Column defaults (Neoview SQL specifies a subset of datetime value functions
that Core '99 allows to be specified. Neoview SQL does not enforce the conformance rule
that “Without Feature F411 “Time zone specification”, CURRENT_TIME and
CURRENT_TIMESTAMP shall not be specified.”)
Neoview SQL does not support these subfeatures:
• E141-08 NOT NULL inferred on PRIMARY KEY
• E141-10 Names in a foreign key can be specified in any order (The column in the column
list associated with REFERENCES must be in the same order as the column in the column
list associated with FOREIGN KEY)
E141 Basic integrity
constraints
The interface does not properly process SQL comments when they are issued from the Manager.E161 SQL comments
using leading double
minus
Neoview SQL Compliance 515