| B011 |
|
Embedded Ada |
|
| B013 |
|
Embedded COBOL |
|
| B014 |
|
Embedded Fortran |
|
| B015 |
|
Embedded MUMPS |
|
| B016 |
|
Embedded Pascal |
|
| B017 |
|
Embedded PL/I |
|
| B031 |
|
Basic dynamic SQL |
|
| B032 |
|
Extended dynamic SQL |
|
| B032-01 |
|
<describe input statement> |
|
| B033 |
|
Untyped SQL-invoked function arguments |
|
| B034 |
|
Dynamic specification of cursor attributes |
|
| B035 |
|
Non-extended descriptor names |
|
| B041 |
|
Extensions to embedded SQL exception declarations |
|
| B051 |
|
Enhanced execution rights |
|
| B111 |
|
Module language Ada |
|
| B112 |
|
Module language C |
|
| B113 |
|
Module language COBOL |
|
| B114 |
|
Module language Fortran |
|
| B115 |
|
Module language MUMPS |
|
| B116 |
|
Module language Pascal |
|
| B117 |
|
Module language PL/I |
|
| B121 |
|
Routine language Ada |
|
| B122 |
|
Routine language C |
|
| B123 |
|
Routine language COBOL |
|
| B124 |
|
Routine language Fortran |
|
| B125 |
|
Routine language MUMPS |
|
| B126 |
|
Routine language Pascal |
|
| B127 |
|
Routine language PL/I |
|
| B128 |
|
Routine language SQL |
|
| B211 |
|
Module language Ada: VARCHAR and NUMERIC support |
|
| B221 |
|
Routine language Ada: VARCHAR and NUMERIC support |
|
| E182 |
Core |
Module language |
|
| F054 |
|
TIMESTAMP in DATE type precedence list |
|
| F121 |
|
Basic diagnostics management |
|
| F121-01 |
|
GET DIAGNOSTICS statement |
|
| F121-02 |
|
SET TRANSACTION statement: DIAGNOSTICS SIZE clause |
|
| F122 |
|
Enhanced diagnostics management |
|
| F123 |
|
All diagnostics |
|
| F181 |
Core |
Multiple module support |
|
| F202 |
|
TRUNCATE TABLE: identity column restart option |
|
| F263 |
|
Comma-separated predicates in simple CASE expression |
|
| F291 |
|
UNIQUE predicate |
|
| F301 |
|
CORRESPONDING in query expressions |
|
| F311 |
Core |
Schema definition statement |
|
| F312 |
|
MERGE statement |
|
| F313 |
|
Enhanced MERGE statement |
|
| F314 |
|
MERGE statement with DELETE branch |
|
| F341 |
|
Usage tables |
no ROUTINE_*_USAGE tables |
| F384 |
|
Drop identity property clause |
|
| F385 |
|
Drop column generation expression clause |
|
| F386 |
|
Set identity column generation clause |
|
| F394 |
|
Optional normal form specification |
|
| F403 |
|
Partitioned joined tables |
|
| F451 |
|
Character set definition |
|
| F461 |
|
Named character sets |
|
| F492 |
|
Optional table constraint enforcement |
|
| F521 |
Enhanced integrity management |
Assertions |
|
| F671 |
Enhanced integrity management |
Subqueries in CHECK |
intentionally omitted |
| F693 |
|
SQL-session and client module collations |
|
| F695 |
|
Translation support |
|
| F696 |
|
Additional translation documentation |
|
| F721 |
|
Deferrable constraints |
foreign and unique keys only |
| F741 |
|
Referential MATCH types |
no partial match yet |
| F812 |
Core |
Basic flagging |
|
| F813 |
|
Extended flagging |
|
| F821 |
|
Local table references |
|
| F831 |
|
Full cursor update |
|
| F831-01 |
|
Updatable scrollable cursors |
|
| F831-02 |
|
Updatable ordered cursors |
|
| F841 |
|
LIKE_REGEX predicate |
|
| F842 |
|
OCCURENCES_REGEX function |
|
| F843 |
|
POSITION_REGEX function |
|
| F844 |
|
SUBSTRING_REGEX function |
|
| F845 |
|
TRANSLATE_REGEX function |
|
| F846 |
|
Octet support in regular expression operators |
|
| F847 |
|
Nonconstant regular expressions |
|
| F866 |
|
FETCH FIRST clause: PERCENT option |
|
| F867 |
|
FETCH FIRST clause: WITH TIES option |
|
| S011 |
Core |
Distinct data types |
|
| S011-01 |
Core |
USER_DEFINED_TYPES view |
|
| S023 |
Basic object support |
Basic structured types |
|
| S024 |
Enhanced object support |
Enhanced structured types |
|
| S025 |
|
Final structured types |
|
| S026 |
|
Self-referencing structured types |
|
| S027 |
|
Create method by specific method name |
|
| S028 |
|
Permutable UDT options list |
|
| S041 |
Basic object support |
Basic reference types |
|
| S043 |
Enhanced object support |
Enhanced reference types |
|
| S051 |
Basic object support |
Create table of type |
partially supported |
| S081 |
Enhanced object support |
Subtables |
|
| S091 |
|
Basic array support |
partially supported |
| S091-01 |
|
Arrays of built-in data types |
|
| S091-02 |
|
Arrays of distinct types |
|
| S091-03 |
|
Array expressions |
|
| S094 |
|
Arrays of reference types |
|
| S097 |
|
Array element assignment |
|
| S151 |
Basic object support |
Type predicate |
|
| S161 |
Enhanced object support |
Subtype treatment |
|
| S162 |
|
Subtype treatment for references |
|
| S202 |
|
SQL-invoked routines on multisets |
|
| S231 |
Enhanced object support |
Structured type locators |
|
| S232 |
|
Array locators |
|
| S233 |
|
Multiset locators |
|
| S241 |
|
Transform functions |
|
| S242 |
|
Alter transform statement |
|
| S251 |
|
User-defined orderings |
|
| S261 |
|
Specific type method |
|
| S271 |
|
Basic multiset support |
|
| S272 |
|
Multisets of user-defined types |
|
| S274 |
|
Multisets of reference types |
|
| S275 |
|
Advanced multiset support |
|
| S281 |
|
Nested collection types |
|
| S291 |
|
Unique constraint on entire row |
|
| S301 |
|
Enhanced UNNEST |
|
| S401 |
|
Distinct types based on array types |
|
| S402 |
|
Distinct types based on distinct types |
|
| S403 |
|
ARRAY_MAX_CARDINALITY |
|
| S404 |
|
TRIM_ARRAY |
|
| T011 |
|
Timestamp in Information Schema |
|
| T021 |
|
BINARY and VARBINARY data types |
|
| T022 |
|
Advanced support for BINARY and VARBINARY data types |
|
| T023 |
|
Compound binary literal |
|
| T024 |
|
Spaces in binary literals |
|
| 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 |
|
| T043 |
|
Multiplier T |
|
| T044 |
|
Multiplier P |
|
| T051 |
|
Row types |
|
| T052 |
|
MAX and MIN for row types |
|
| T053 |
|
Explicit aliases for all-fields reference |
|
| T061 |
|
UCS support |
|
| T101 |
|
Enhanced nullability determination |
|
| T111 |
|
Updatable joins, unions, and columns |
|
| T174 |
|
Identity columns |
|
| T175 |
|
Generated columns |
|
| T176 |
|
Sequence generator support |
|
| T177 |
|
Sequence generator support: simple restart option |
|
| T178 |
|
Identity columns: simple restart option |
|
| T180 |
|
System-versioned tables |
|
| T181 |
|
Application-time period tables |
|
| T211 |
Active database, Enhanced integrity management |
Basic trigger capability |
|
| T211-06 |
Active database, Enhanced integrity management |
Support for run-time rules for the interaction of triggers and constraints |
|
| T211-08 |
Active database, Enhanced integrity management |