Feature ID
|
Feature description
|
B128
|
Routine language SQL
|
F033
|
ALTER TABLE statement: DROP COLUMN clause
|
F052
|
Intervals and datetime arithmetic
|
F171
|
Multiple schemas per user
|
F191
|
Referential delete actions
|
F222
|
INSERT statement: DEFAULT VALUES clause
|
F271
|
Compound character literals
|
F281
|
LIKE enhancements
|
F291
|
UNIQUE predicate
|
F302
|
INTERSECT table operator
|
F302-01
|
INTERSECT DISTINCT table operator
|
F302-02
|
INTERSECT ALL table operator
|
F304
|
EXCEPT ALL table operator
|
F381
|
Extended schema manipulation
|
F381-01
|
ALTER TABLE statement: ALTER COLUMN clause
|
F381-02
|
ALTER TABLE statement: ADD CONSTRAINT clause
|
F381-03
|
ALTER TABLE statement: DROP CONSTRAINT clause
|
F391
|
Long identifiers
|
F401
|
Extended joined table
|
F401-01
|
NATURAL JOIN
|
F401-02
|
FULL OUTER JOIN
|
F401-04
|
CROSS JOIN
|
F421
|
National character
|
F491
|
Constraint management
|
F531
|
Temporary tables
|
F561
|
Full value expressions
|
F571
|
Truth value tests
|
F591
|
Derived tables
|
F671
|
Subqueries in CHECK constraints
|
F672
|
Retrospective check constraints
|
F692
|
Enhanced collation support
|
F701
|
Referential update actions
|
F741
|
Referential MATCH types
|
T031
|
BOOLEAN data type
|
T041
|
Basic LOB data type support
|
T041-01
|
BLOB data type
|
T041-02
|
CLOB data type
|
T041-03
|
POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions
for LOB data types
|
T041-04
|
Concatenation of LOB data types
|
T071
|
BIGINT data type
|
T171
|
LIKE clause in table definition
|
T172
|
AS subquery clause in table definition
|
T191
|
Referential action RESTRICT
|
T201
|
Comparable data types for referential constraints
|
T211
|
Basic trigger capability
|
T211-01
|
Triggers activated on UPDATE, INSERT, or DELETE of one base table.
|
T211-02
|
BEFORE triggers
|
T211-03
|
AFTER triggers
|
T211-04
|
FOR EACH ROW triggers
|
T211-05
|
Ability to specify a search condition that shall be True before the trigger is invoked.
|
T241
|
START TRANSACTION statement
|
T326
|
Table functions
|
T351
|
Bracketed SQL comments (/*...*/ comments)
|
T441
|
ABS and MOD functions
|
T501
|
Enhanced EXISTS predicate
|
T551
|
Optional key words for default syntax
|
T591
|
UNIQUE constraints of possibly null columns
|
T621
|
Enhanced numeric functions
|
T651
|
SQL-schema statements in SQL routines
|
T653
|
SQL-schema statements in external routines
|
P002
|
Computational completeness
|
P002-01
|
<compound statement>
|
P002-04
|
<SQL variable declaration>
|
P002-05
|
<assignment statement>
|
P002-07
|
<if statement>
|
P002-08
|
<iterate statement>
|
P002-09
|
<leave statement>
|
P002-11
|
<repeat statement>
|
P002-12
|
<while statement>
|
P002-14
|
<signal statement>
|
