Intermediate SQL Flagging
Derby Reference Manual
218
Feature
Source
Derby
Subprogram support
SQL92I
Not relevant to JDBC,
which is much richer
Intermediate SQL Flagging
SQL92I
No
Schema manipulation
SQL92I
Yes
Long identifiers
SQL92I
Yes
Full outer join
SQL92I
No
Time zone specification
SQL92I
No
Scrolled cursors
SQL92I
Partial support
(scrollable insensitive
result sets through
JDBC 2.0)
Intermediate set function support
SQL92I
Partial support
Character set definition
SQL92I
Support for Java locales
Named character sets
SQL92I
Support for Java locales
Scalar subquery values
SQL92I
Yes
Expanded null predicate
SQL92I
Yes
Constraint management
SQL92I
Yes (ADD/DROP
CONSTRAINT)
FOR BIT DATA types
SQL92F
Yes
Assertion constraints
SQL92F
No
Temporary tables
SQL92F
Partial support, with
DECLARE GLOBAL
TEMPORARY TABLE
Full dynamic SQL
SQL92F
No
Full value expressions
SQL92F
Yes
Truth value tests
SQL92F
Yes
Derived tables in FROM
SQL92F
Yes
Trailing underscore
SQL92F
Yes
Indicator data types
SQL92F
Not relevant to JDBC
Referential name order
SQL92F
No
Full SQL Flagging
SQL92F
No
Row and table constructors
SQL92F
Yes
Catalog name qualifiers
SQL92F
No
Simple tables
SQL92F
No
Subqueries in CHECK
SQL92F
No, but can with Java
methods
Union join
SQL92F
No
Collation and translation
SQL92F
Java locales supported
Referential update actions
SQL92F
