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 | |