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 | |
F311-04 | Core | CREATE VIEW: WITH CHECK OPTION | |
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 |
F751 | | View CHECK enhancements | |
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 | Multiple triggers for the same event are executed in the order in which they were created in the catalog | intentionally omitted |
T251 | | SET TRANSACTION statement: LOCAL option | |
T261 | | Chained transactions | |
T272 | | Enhanced savepoint management | |
T285 | | Enhanced derived column names | |
T301 | | Functional dependencies | partially supported |
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 | |
T322 | PSM | Declared data type attributes | |
T324 | | Explicit security for SQL routines | |
T325 | | Qualified SQL parameter references | |
T326 | | Table functions | |
T332 | | Extended roles | mostly supported |
T431 | OLAP | Extended grouping capabilities | |
T432 | | Nested and concatenated GROUPING SETS | |
T433 | | Multiargument GROUPING function | |
T434 | | GROUP BY DISTINCT | |
T471 | | Result sets return value | |
T472 | | DESCRIBE CURSOR | |
T495 | | Combined data change and retrieval | different syntax |
T502 | | Period predicates | |
T511 | | Transaction counts | |
T521 | | Named arguments in CALL statement | |
T522 | | Default values for IN parameters of SQL-invoked procedures | |
T541 | | Updatable table references | |
T561 | | Holdable locators | |
T571 | | Array-returning external SQL-invoked functions | |
T572 | | Multiset-returning external SQL-invoked functions | |
T601 | | Local cursor references | |
T611 | OLAP | Elementary OLAP operations | most forms supported |
T612 | | Advanced OLAP operations | some forms supported |
T613 | | Sampling | |
T616 | | Null treatment option for LEAD and LAG functions | |
T618 | | NTH_VALUE function | function exists, but some options missing |
T619 | | Nested window functions | |
T620 | | WINDOW clause: GROUPS option | |
T641 | | Multiple column assignment | only some syntax variants supported |
T652 | | SQL-dynamic statements in SQL routines | |
T653 | | SQL-schema statements in external routines | |
T654 | | SQL-dynamic statements in external routines | |
M001 | | Datalinks | |
M002 | | Datalinks via SQL/CLI | |
M003 | | Datalinks via Embedded SQL | |
M004 | | Foreign data support | partially supported |
M005 | | Foreign schema support | |
M006 | | GetSQLString routine | |
M007 | | TransmitRequest | |
M009 | | GetOpts and GetStatistics routines | |
M010 | | Foreign data wrapper support | different API |
M011 | | Datalinks via Ada | |
M012 | | Datalinks via C | |
M013 | | Datalinks via COBOL | |
M014 | | Datalinks via Fortran | |
M015 | | Datalinks via M | |
M016 | | Datalinks via Pascal | |
M017 | | Datalinks via PL/I | |
M018 | | Foreign data wrapper interface routines in Ada | |
M019 | | Foreign data wrapper interface routines in C | different API |
M020 | | Foreign data wrapper interface routines in COBOL | |
M021 | | Foreign data wrapper interface routines in Fortran | |
M022 | | Foreign data wrapper interface routines in MUMPS | |
M023 | | Foreign data wrapper interface routines in Pascal | |
M024 | | Foreign data wrapper interface routines in PL/I | |
M030 | | SQL-server foreign data support | |
M031 | | Foreign data wrapper general routines | |
X012 | | Multisets of XML type | |
X013 | | Distinct types of XML type | |
X014 | | Attributes of XML type | |
X015 | | Fields of XML type | |
X025 | | XMLCast | |
X030 | | XMLDocument | |
X038 | | XMLText | |
X065 | | XMLParse: BLOB input and CONTENT option | |
X066 | | XMLParse: BLOB input and DOCUMENT option | |
X068 | | XMLSerialize: BOM | |
X069 | | XMLSerialize: INDENT | |
X073 | | XMLSerialize: BLOB serialization and CONTENT option | |
X074 | | XMLSerialize: BLOB serialization and DOCUMENT option | |
X075 | | XMLSerialize: BLOB serialization | |
X076 | | XMLSerialize: VERSION | |
X077 | | XMLSerialize: explicit ENCODING option | |
X078 | | XMLSerialize: explicit XML declaration | |
X080 | | Namespaces in XML publishing | |
X081 | | Query-level XML namespace declarations | |
X082 | | XML namespace declarations in DML | |
X083 | | XML namespace declarations in DDL | |
X084 | | XML namespace declarations in compound statements | |
X085 | | Predefined namespace prefixes | |
X086 | | XML namespace declarations in XMLTable | |
X091 | | XML content predicate | |
X096 | | XMLExists | |
X100 | | Host language support for XML: CONTENT option | |
X101 | | Host language support for XML: DOCUMENT option | |
X110 | | Host language support for XML: VARCHAR mapping | |
X111 | | Host language support for XML: CLOB mapping | |
X112 | | Host language support for XML: BLOB mapping | |
X113 | | Host language support for XML: STRIP WHITESPACE option | |
X114 | | Host language support for XML: PRESERVE WHITESPACE option | |
X131 | | Query-level XMLBINARY clause | |
X132 | | XMLBINARY clause in DML | |
X133 | | XMLBINARY clause in DDL | |
X134 | | XMLBINARY clause in compound statements | |
X135 | | XMLBINARY clause in subqueries | |
X141 | | IS VALID predicate: data-driven case | |
X142 | | IS VALID predicate: ACCORDING TO clause | |
X143 | | IS VALID predicate: ELEMENT clause | |
X144 | | IS VALID predicate: schema location | |
X145 | | IS VALID predicate outside check constraints | |
X151 | | IS VALID predicate with DOCUMENT option | |
X152 | | IS VALID predicate with CONTENT option | |
X153 | | IS VALID predicate with SEQUENCE option | |
X155 | | IS VALID predicate: NAMESPACE without ELEMENT clause | |
X157 | | IS VALID predicate: NO NAMESPACE with ELEMENT clause | |
X160 | | Basic Information Schema for registered XML Schemas | |
X161 | | Advanced Information Schema for registered XML Schemas | |
X170 | | XML null handling options | |
X171 | | NIL ON NO CONTENT option | |
X181 | | XML(DOCUMENT(UNTYPED)) type | |
X182 | | XML(DOCUMENT(ANY)) type | |
X190 | | XML(SEQUENCE) type | |
X191 | | XML(DOCUMENT(XMLSCHEMA)) type | |
X192 | | XML(CONTENT(XMLSCHEMA)) type | |
X200 | | XMLQuery | |
X201 | | XMLQuery: RETURNING CONTENT | |
X202 | | XMLQuery: RETURNING SEQUENCE | |
X203 | | XMLQuery: passing a context item | |
X204 | | XMLQuery: initializing an XQuery variable | |
X205 | | XMLQuery: EMPTY ON EMPTY option | |
X206 | | XMLQuery: NULL ON EMPTY option | |
X211 | | XML 1.1 support | |
X221 | | XML passing mechanism BY VALUE | |
X222 | | XML passing mechanism BY REF | |
X231 | | XML(CONTENT(UNTYPED)) type | |
X232 | | XML(CONTENT(ANY)) type | |
X241 | | RETURNING CONTENT in XML publishing | |
X242 | | RETURNING SEQUENCE in XML publishing | |
X251 | | Persistent XML values of XML(DOCUMENT(UNTYPED)) type | |
X252 | | Persistent XML values of XML(DOCUMENT(ANY)) type | |
X253 | | Persistent XML values of XML(CONTENT(UNTYPED)) type | |
X254 | | Persistent XML values of XML(CONTENT(ANY)) type | |
X255 | | Persistent XML values of XML(SEQUENCE) type | |
X256 | | Persistent XML values of XML(DOCUMENT(XMLSCHEMA)) type | |
X257 | | Persistent XML values of XML(CONTENT(XMLSCHEMA)) type | |
X260 | | XML type: ELEMENT clause | |
X261 | | XML type: NAMESPACE without ELEMENT clause | |
X263 | | XML type: NO NAMESPACE with ELEMENT clause | |
X264 | | XML type: schema location | |
X271 | | XMLValidate: data-driven case | |
X272 | | XMLValidate: ACCORDING TO clause | |
X273 | | XMLValidate: ELEMENT clause | |
X274 | | XMLValidate: schema location | |
X281 | | XMLValidate: with DOCUMENT option | |
X282 | | XMLValidate with CONTENT option | |
X283 | | XMLValidate with SEQUENCE option | |
X284 | | XMLValidate NAMESPACE without ELEMENT clause | |
X286 | | XMLValidate: NO NAMESPACE with ELEMENT clause | |
X300 | | XMLTable | |
X301 | | XMLTable: derived column list option | |
X302 | | XMLTable: ordinality column option | |
X303 | | XMLTable: column default option | |
X304 | | XMLTable: passing a context item | |
X305 | | XMLTable: initializing an XQuery variable | |