| B011 |
Core |
Embedded Ada |
|
| B013 |
Core |
Embedded COBOL |
|
| B014 |
Core |
Embedded Fortran |
|
| B015 |
Core |
Embedded MUMPS |
|
| B016 |
Core |
Embedded Pascal |
|
| B017 |
Core |
Embedded PL/I |
|
| B031 |
|
Basic dynamic SQL |
|
| B032 |
|
Extended dynamic SQL |
|
| B032-01 |
|
<describe input> statement |
|
| B041 |
|
Extensions to embedded SQL exception
declarations |
|
| B051 |
|
Enhanced execution rights |
|
| E081 |
Core |
Basic Privileges |
|
| E081-05 |
Core |
UPDATE privilege at the column level |
|
| E081-07 |
Core |
REFERENCES privilege at the column level |
|
| E121 |
Core |
Basic cursor support |
|
| E121-06 |
Core |
Positioned UPDATE statement |
|
| E121-07 |
Core |
Positioned DELETE statement |
|
| E153 |
Core |
Updatable queries with subqueries |
|
| E182 |
Core |
Module language |
|
| F111 |
|
Isolation levels other than SERIALIZABLE |
|
| F111-01 |
|
READ UNCOMMITTED isolation level |
|
| F111-03 |
|
REPEATABLE READ isolation level |
|
| F121 |
|
Basic diagnostics management |
|
| F121-01 |
|
GET DIAGNOSTICS statement |
|
| F121-02 |
|
SET TRANSACTION statement: DIAGNOSTICS SIZE
clause |
|
| F181 |
|
Multiple module support |
|
| F291 |
|
UNIQUE predicate |
|
| F301 |
|
CORRESPONDING in query expressions |
|
| F311 |
Core |
Schema definition statement |
|
| F311-04 |
Core |
CREATE VIEW: WITH CHECK OPTION |
|
| F341 |
|
Usage tables |
|
| F451 |
|
Character set definition |
|
| F461 |
|
Named character sets |
|
| F521 |
Enhanced integrity management |
Assertions |
|
| F641 |
OLAP facilities |
Row and table constructors |
|
| F661 |
|
Simple tables |
|
| F671 |
Enhanced integrity management |
Subqueries in CHECK |
intentionally omitted |
| F691 |
|
Collation and translation |
|
| F721 |
|
Deferrable constraints |
foreign keys only |
| F731 |
|
INSERT column privileges |
|
| F741 |
|
Referential MATCH types |
no partial match yet |
| F751 |
|
View CHECK enhancements |
|
| F811 |
|
Extended flagging |
|
| F812 |
Core |
Basic flagging |
|
| F813 |
|
Extended flagging for "Core SQL Flagging" and
"Catalog Lookup" only |
|
| F821 |
|
Local table references |
|
| F831 |
|
Full cursor update |
|
| F831-01 |
|
Updatable scrollable cursors |
|
| F831-02 |
|
Updatable ordered cursors |
|
| S011 |
Core |
Distinct data types |
|
| S011-01 |
Core |
USER_DEFINED_TYPES view |
|
| S023 |
Basic object support, SQL/MM support |
Basic structured types |
|
| S024 |
Enhanced object support, SQL/MM support |
Enhanced structured types |
|
| S041 |
Basic object support |
Basic reference types |
|
| S043 |
Enhanced object support |
Enhanced reference types |
|
| S051 |
Basic object support |
Create table of type |
|
| S081 |
Enhanced object support |
Subtables |
|
| S091 |
SQL/MM support |
Basic array support |
|
| S091-01 |
SQL/MM support |
Arrays of built-in data types |
|
| S091-02 |
SQL/MM support |
Arrays of distinct types |
|
| S091-03 |
SQL/MM support |
Array expressions |
|
| S092 |
SQL/MM support |
Arrays of user-defined types |
|
| S094 |
|
Arrays of reference types |
|
| S151 |
Basic object support |
Type predicate |
|
| S161 |
Enhanced object support |
Subtype treatment |
|
| S201 |
|
SQL routines on arrays |
|
| S201-01 |
|
Array parameters |
|
| S201-02 |
|
Array as result type of functions |
|
| S231 |
Enhanced object support |
Structured type locators |
|
| S232 |
|
Array locators |
|
| S241 |
Enhanced object support |
Transform functions |
|
| S251 |
|
User-defined orderings |
|
| S261 |
|
Specific type method |
|
| T011 |
|
Timestamp in Information Schema |
|
| T041 |
Basic object support |
Basic LOB data type support |
|
| T041-01 |
Basic object support |
BLOB data type |
|
| T041-02 |
Basic object support |
CLOB data type |
|
| T041-03 |
Basic object support |
POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING
functions for LOB data types |
|
| T041-04 |
Basic object support |
Concatenation of LOB data types |
|
| T041-05 |
Basic object support |
LOB locator: non-holdable |
|
| T042 |
|
Extended LOB data type support |
|
| T051 |
|
Row types |
|
| T111 |
|
Updatable joins, unions, and columns |
|
| T121 |
|
WITH (excluding RECURSIVE) in query expression |
|
| T131 |
|
Recursive query |
|
| T211 |
Enhanced integrity management, Active database |
Basic trigger capability |
|
| T211-05 |
Enhanced integrity management, Active database |
Ability to specify a search condition that must be
true before the trigger is invoked |
|
| T211-06 |
Enhanced integrity management, Active database |
Support for run-time rules for the interaction of
triggers and constraints |
|
| T211-08 |
Enhanced integrity management, Active database |
Multiple triggers for the same event are executed in
the order in which they were created |
intentionally omitted |
| T251 |
|
SET TRANSACTION statement: LOCAL option |
|
| T261 |
|
Chained transactions |
|
| T271 |
|
Savepoints |
|
| T281 |
|
SELECT privilege with column granularity |
|
| T301 |
|
Functional Dependencies |
|
| T321 |
Core |
Basic SQL-invoked routines |
|
| T321-02 |
Core |
User-defined stored procedures with no
overloading |
|
| T321-04 |
Core |
CALL statement |
|
| T321-05 |
Core |
RETURN statement |
|
| T331 |
|
Basic roles |
|
| T332 |
|
Extended roles |
|
| T401 |
|
INSERT into a cursor |
|
| T411 |
|
UPDATE statement: SET ROW option |
|
| T431 |
OLAP facilities |
CUBE and ROLLUP operations |
|
| T461 |
|
Symmetric BETWEEN predicate |
|
| T471 |
|
Result sets return value |
|
| T491 |
|
LATERAL derived table |
|
| T511 |
|
Transaction counts |
|
| T541 |
|
Updatable table references |
|
| T561 |
|
Holdable locators |
|
| T571 |
|
Array-returning external SQL-invoked functions |
|
| T601 |
|
Local cursor references |
|