| B011 Embedded Ada NO |
| B012 Embedded C YES |
| B013 Embedded COBOL NO |
| B014 Embedded Fortran NO |
| B015 Embedded MUMPS NO |
| B016 Embedded Pascal NO |
| B017 Embedded PL/I NO |
| B021 Direct SQL YES |
| B031 Basic dynamic SQL NO |
| B032 Extended dynamic SQL NO |
| B032 Extended dynamic SQL 01 <describe input statement> NO |
| B033 Untyped SQL-invoked function arguments NO |
| B034 Dynamic specification of cursor attributes NO |
| B035 Non-extended descriptor names NO |
| B041 Extensions to embedded SQL exception declarations NO |
| B051 Enhanced execution rights NO |
| B111 Module language Ada NO |
| B112 Module language C NO |
| B113 Module language COBOL NO |
| B114 Module language Fortran NO |
| B115 Module language MUMPS NO |
| B116 Module language Pascal NO |
| B117 Module language PL/I NO |
| B121 Routine language Ada NO |
| B122 Routine language C NO |
| B123 Routine language COBOL NO |
| B124 Routine language Fortran NO |
| B125 Routine language MUMPS NO |
| B126 Routine language Pascal NO |
| B127 Routine language PL/I NO |
| B128 Routine language SQL NO |
| E011 Numeric data types YES |
| E011 Numeric data types 01 INTEGER and SMALLINT data types YES |
| E011 Numeric data types 02 REAL, DOUBLE PRECISION, and FLOAT data types YES |
| E011 Numeric data types 03 DECIMAL and NUMERIC data types YES |
| E011 Numeric data types 04 Arithmetic operators YES |
| E011 Numeric data types 05 Numeric comparison YES |
| E011 Numeric data types 06 Implicit casting among the numeric data types YES |
| E021 Character data types YES |
| E021 Character string types 01 CHARACTER data type YES |
| E021 Character string types 02 CHARACTER VARYING data type YES |
| E021 Character string types 03 Character literals YES |
| E021 Character string types 04 CHARACTER_LENGTH function YES trims trailing spaces from CHARACTER values before counting |
| E021 Character string types 05 OCTET_LENGTH function YES |
| E021 Character string types 06 SUBSTRING function YES |
| E021 Character string types 07 Character concatenation YES |
| E021 Character string types 08 UPPER and LOWER functions YES |
| E021 Character string types 09 TRIM function YES |
| E021 Character string types 10 Implicit casting among the character string types YES |
| E021 Character string types 11 POSITION function YES |
| E021 Character string types 12 Character comparison YES |
| E031 Identifiers YES |
| E031 Identifiers 01 Delimited identifiers YES |
| E031 Identifiers 02 Lower case identifiers YES |
| E031 Identifiers 03 Trailing underscore YES |
| E051 Basic query specification YES |
| E051 Basic query specification 01 SELECT DISTINCT YES |
| E051 Basic query specification 02 GROUP BY clause YES |
| E051 Basic query specification 04 GROUP BY can contain columns not in <select list> YES |
| E051 Basic query specification 05 Select list items can be renamed YES |
| E051 Basic query specification 06 HAVING clause YES |
| E051 Basic query specification 07 Qualified * in select list YES |
| E051 Basic query specification 08 Correlation names in the FROM clause YES |
| E051 Basic query specification 09 Rename columns in the FROM clause YES |
| E061 Basic predicates and search conditions YES |
| E061 Basic predicates and search conditions 01 Comparison predicate YES |
| E061 Basic predicates and search conditions 02 BETWEEN predicate YES |
| E061 Basic predicates and search conditions 03 IN predicate with list of values YES |
| E061 Basic predicates and search conditions 04 LIKE predicate YES |
| E061 Basic predicates and search conditions 05 LIKE predicate ESCAPE clause YES |
| E061 Basic predicates and search conditions 06 NULL predicate YES |
| E061 Basic predicates and search conditions 07 Quantified comparison predicate YES |
| E061 Basic predicates and search conditions 08 EXISTS predicate YES not all uses work |
| E061 Basic predicates and search conditions 09 Subqueries in comparison predicate YES |
| E061 Basic predicates and search conditions 11 Subqueries in IN predicate YES |
| E061 Basic predicates and search conditions 12 Subqueries in quantified comparison predicate YES |
| E061 Basic predicates and search conditions 13 Correlated subqueries NO |
| E061 Basic predicates and search conditions 14 Search condition YES |
| E071 Basic query expressions YES |
| E071 Basic query expressions 01 UNION DISTINCT table operator YES |
| E071 Basic query expressions 02 UNION ALL table operator YES |
| E071 Basic query expressions 03 EXCEPT DISTINCT table operator YES |
| E071 Basic query expressions 05 Columns combined via table operators need not have exactly the same data type YES |
| E071 Basic query expressions 06 Table operators in subqueries YES |
| E081 Basic Privileges NO |
| E081 Basic Privileges 01 SELECT privilege YES |
| E081 Basic Privileges 02 DELETE privilege YES |
| E081 Basic Privileges 03 INSERT privilege at the table level YES |
| E081 Basic Privileges 04 UPDATE privilege at the table level YES |
| E081 Basic Privileges 05 UPDATE privilege at the column level NO |
| E081 Basic Privileges 06 REFERENCES privilege at the table level YES |
| E081 Basic Privileges 07 REFERENCES privilege at the column level NO |
| E081 Basic Privileges 08 WITH GRANT OPTION YES |
| E081 Basic Privileges 09 USAGE privilege NO |
| E081 Basic Privileges 10 EXECUTE privilege YES |
| E091 Set functions YES |
| E091 Set functions 01 AVG YES |
| E091 Set functions 02 COUNT YES |
| E091 Set functions 03 MAX YES |
| E091 Set functions 04 MIN YES |
| E091 Set functions 05 SUM YES |
| E091 Set functions 06 ALL quantifier YES |
| E091 Set functions 07 DISTINCT quantifier YES |
| E101 Basic data manipulation YES |
| E101 Basic data manipulation 01 INSERT statement YES |
| E101 Basic data manipulation 03 Searched UPDATE statement YES |
| E101 Basic data manipulation 04 Searched DELETE statement YES |
| E111 Single row SELECT statement YES |
| E121 Basic cursor support YES |
| E121 Basic cursor support 01 DECLARE CURSOR YES |
| E121 Basic cursor support 02 ORDER BY columns need not be in select list YES |
| E121 Basic cursor support 03 Value expressions in ORDER BY clause YES |
| E121 Basic cursor support 04 OPEN statement YES |
| E121 Basic cursor support 06 Positioned UPDATE statement NO |
| E121 Basic cursor support 07 Positioned DELETE statement NO |
| E121 Basic cursor support 08 CLOSE statement YES |
| E121 Basic cursor support 10 FETCH statement implicit NEXT YES |
| E121 Basic cursor support 17 WITH HOLD cursors YES |
| E131 Null value support (nulls in lieu of values) YES |
| E141 Basic integrity constraints YES |
| E141 Basic integrity constraints 01 NOT NULL constraints YES |
| E141 Basic integrity constraints 02 UNIQUE constraints of NOT NULL columns YES |
| E141 Basic integrity constraints 03 PRIMARY KEY constraints YES |
| E141 Basic integrity constraints 04 Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action NO |
| E141 Basic integrity constraints 06 CHECK constraints YES |
| E141 Basic integrity constraints 07 Column defaults YES |
| E141 Basic integrity constraints 08 NOT NULL inferred on PRIMARY KEY YES |
| E141 Basic integrity constraints 10 Names in a foreign key can be specified in any order YES |
| E151 Transaction support YES |
| E151 Transaction support 01 COMMIT statement YES |
| E151 Transaction support 02 ROLLBACK statement YES |
| E152 Basic SET TRANSACTION statement YES |
| E152 Basic SET TRANSACTION statement 01 SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause YES |
| E152 Basic SET TRANSACTION statement 02 SET TRANSACTION statement: READ ONLY and READ WRITE clauses YES |
| E153 Updatable queries with subqueries NO |
| E161 SQL comments using leading double minus YES |
| E171 SQLSTATE support YES |
| E182 Module language NO |
| F021 Basic information schema YES |
| F021 Basic information schema 01 COLUMNS view YES |
| F021 Basic information schema 02 TABLES view YES |
| F021 Basic information schema 03 VIEWS view YES |
| F021 Basic information schema 04 TABLE_CONSTRAINTS view YES |
| F021 Basic information schema 05 REFERENTIAL_CONSTRAINTS view YES |
| F021 Basic information schema 06 CHECK_CONSTRAINTS view YES |
| F031 Basic schema manipulation YES |
| F031 Basic schema manipulation 01 CREATE TABLE statement to create persistent base tables YES |
| F031 Basic schema manipulation 02 CREATE VIEW statement YES |
| F031 Basic schema manipulation 03 GRANT statement YES |
| F031 Basic schema manipulation 04 ALTER TABLE statement: ADD COLUMN clause YES |
| F031 Basic schema manipulation 13 DROP TABLE statement: RESTRICT clause YES |
| F031 Basic schema manipulation 16 DROP VIEW statement: RESTRICT clause YES |
| F031 Basic schema manipulation 19 REVOKE statement: RESTRICT clause YES |
| F032 CASCADE drop behavior YES |
| F033 ALTER TABLE statement: DROP COLUMN clause YES |
| F034 Extended REVOKE statement YES |
| F034 Extended REVOKE statement 01 REVOKE statement performed by other than the owner of a schema object YES |
| F034 Extended REVOKE statement 02 REVOKE statement: GRANT OPTION FOR clause YES |
| F034 Extended REVOKE statement 03 REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION YES |
| F041 Basic joined table YES |
| F041 Basic joined table 01 Inner join (but not necessarily the INNER keyword) YES |
| F041 Basic joined table 02 INNER keyword YES |
| F041 Basic joined table 03 LEFT OUTER JOIN YES |
| F041 Basic joined table 04 RIGHT OUTER JOIN YES |
| F041 Basic joined table 05 Outer joins can be nested YES |
| F041 Basic joined table 07 The inner table in a left or right outer join can also be used in an inner join YES |
| F041 Basic joined table 08 All comparison operators are supported (rather than just =) YES |
| F051 Basic date and time YES |
| F051 Basic date and time 01 DATE data type (including support of DATE literal) YES |
| F051 Basic date and time 02 TIME data type (including support of TIME literal) with fractional seconds precision of at least 0 YES |
| F051 Basic date and time 03 TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6 YES |
| F051 Basic date and time 04 Comparison predicate on DATE, TIME, and TIMESTAMP data types YES |
| F051 Basic date and time 05 Explicit CAST between datetime types and character string types YES |
| F051 Basic date and time 06 CURRENT_DATE YES |
| F051 Basic date and time 07 LOCALTIME YES |
| F051 Basic date and time 08 LOCALTIMESTAMP YES |
| F052 Intervals and datetime arithmetic YES |
| F053 OVERLAPS predicate YES |
| F081 UNION and EXCEPT in views YES |
| F111 Isolation levels other than SERIALIZABLE YES |
| F111 Isolation levels other than SERIALIZABLE 01 READ UNCOMMITTED isolation level NO |
| F111 Isolation levels other than SERIALIZABLE 02 READ COMMITTED isolation level YES |
| F111 Isolation levels other than SERIALIZABLE 03 REPEATABLE READ isolation level NO |
| F121 Basic diagnostics management NO |
| F121 Basic diagnostics management 01 GET DIAGNOSTICS statement NO |
| F121 Basic diagnostics management 02 SET TRANSACTION statement: DIAGNOSTICS SIZE clause NO |
| F122 Enhanced diagnostics management NO |
| F123 All diagnostics NO |
| F131 Grouped operations YES |
| F131 Grouped operations 01 WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views YES |
| F131 Grouped operations 02 Multiple tables supported in queries with grouped views YES |
| F131 Grouped operations 03 Set functions supported in queries with grouped views YES |
| F131 Grouped operations 04 Subqueries with GROUP BY and HAVING clauses and grouped views YES |
| F131 Grouped operations 05 Single row SELECT with GROUP BY and HAVING clauses and grouped views YES |
| F171 Multiple schemas per user YES |
| F181 Multiple module support NO |
| F191 Referential delete actions NO |
| F200 TRUNCATE TABLE statement YES |
| F201 CAST function YES |
| F202 TRUNCATE TABLE: identity column restart option NO |
| F221 Explicit defaults YES |
| F222 INSERT statement: DEFAULT VALUES clause YES |
| F231 Privilege tables YES |
| F231 Privilege tables 01 TABLE_PRIVILEGES view YES |
| F231 Privilege tables 02 COLUMN_PRIVILEGES view YES |
| F231 Privilege tables 03 USAGE_PRIVILEGES view YES |
| F251 Domain support YES |
| F261 CASE expression YES |
| F261 CASE expression 01 Simple CASE YES |
| F261 CASE expression 02 Searched CASE YES |
| F261 CASE expression 03 NULLIF YES |
| F261 CASE expression 04 COALESCE YES |
| F262 Extended CASE expression NO |
| F263 Comma-separated predicates in simple CASE expression NO |
| F271 Compound character literals YES |
| F281 LIKE enhancements YES |
| F291 UNIQUE predicate NO |
| F301 CORRESPONDING in query expressions NO |
| F302 INTERSECT table operator YES |
| F302 INTERSECT table operator 01 INTERSECT DISTINCT table operator YES |
| F302 INTERSECT table operator 02 INTERSECT ALL table operator YES |
| F304 EXCEPT ALL table operator YES |
| F311 Schema definition statement NO |
| F311 Schema definition statement 01 CREATE SCHEMA YES |
| F311 Schema definition statement 02 CREATE TABLE for persistent base tables YES |
| F311 Schema definition statement 03 CREATE VIEW YES |
| F311 Schema definition statement 04 CREATE VIEW: WITH CHECK OPTION NO |
| F311 Schema definition statement 05 GRANT statement YES |
| F312 MERGE statement NO |
| F313 Enhanced MERGE statement NO |
| F321 User authorization YES |
| F341 Usage tables NO |
| F361 Subprogram support YES |
| F381 Extended schema manipulation YES |
| F381 Extended schema manipulation 01 ALTER TABLE statement: ALTER COLUMN clause YES |
| F381 Extended schema manipulation 02 ALTER TABLE statement: ADD CONSTRAINT clause YES |
| F381 Extended schema manipulation 03 ALTER TABLE statement: DROP CONSTRAINT clause YES |
| F382 Alter column data type YES |
| F391 Long identifiers YES |
| F392 Unicode escapes in identifiers NO |
| F393 Unicode escapes in literals NO |
| F394 Optional normal form specification NO |
| F401 Extended joined table YES |
| F401 Extended joined table 01 NATURAL JOIN YES |
| F401 Extended joined table 02 FULL OUTER JOIN YES |
| F401 Extended joined table 04 CROSS JOIN YES |
| F402 Named column joins for LOBs, arrays, and multisets NO |
| F403 Partitioned joined tables NO |
| F411 Time zone specification YES differences regarding literal interpretation |
| F421 National character YES |
| F431 Read-only scrollable cursors YES forward scroll only |
| F431 Read-only scrollable cursors 01 FETCH with explicit NEXT YES |
| F431 Read-only scrollable cursors 02 FETCH FIRST NO |
| F431 Read-only scrollable cursors 03 FETCH LAST YES |
| F431 Read-only scrollable cursors 04 FETCH PRIOR NO |
| F431 Read-only scrollable cursors 05 FETCH ABSOLUTE NO |
| F431 Read-only scrollable cursors 06 FETCH RELATIVE NO |
| F441 Extended set function support YES |
| F442 Mixed column references in set functions YES |
| F451 Character set definition NO |
| F461 Named character sets NO |
| F471 Scalar subquery values YES |
| F481 Expanded NULL predicate YES |
| F491 Constraint management YES |
| F501 Features and conformance views YES |
| F501 Features and conformance views 01 SQL_FEATURES view YES |
| F501 Features and conformance views 02 SQL_SIZING view YES |
| F501 Features and conformance views 03 SQL_LANGUAGES view YES |
| F502 Enhanced documentation tables YES |
| F502 Enhanced documentation tables 01 SQL_SIZING_PROFILES view YES |
| F502 Enhanced documentation tables 02 SQL_IMPLEMENTATION_INFO view YES |
| F502 Enhanced documentation tables 03 SQL_PACKAGES view YES |
| F521 Assertions NO |
| F531 Temporary tables YES non-standard form |
| F555 Enhanced seconds precision YES |
| F561 Full value expressions YES |
| F571 Truth value tests YES |
| F591 Derived tables YES |
| F611 Indicator data types YES |
| F641 Row and table constructors NO |
| F651 Catalog name qualifiers YES |
| F661 Simple tables NO |
| F671 Subqueries in CHECK NO intentionally omitted |
| F672 Retrospective check constraints YES |
| F690 Collation support NO |
| F692 Enhanced collation support NO |
| F693 SQL-session and client module collations NO |
| F695 Translation support NO |
| F696 Additional translation documentation NO |
| F701 Referential update actions NO |
| F711 ALTER domain YES |
| F721 Deferrable constraints NO |
| F731 INSERT column privileges NO |
| F741 Referential MATCH types NO no partial match yet |
| F751 View CHECK enhancements NO |
| F761 Session management YES |
| F762 CURRENT_CATALOG NO |
| F763 CURRENT_SCHEMA NO |
| F771 Connection management YES |
| F781 Self-referencing operations YES |
| F791 Insensitive cursors YES |
| F801 Full set function YES |
| F812 Basic flagging NO |
| F813 Extended flagging NO |
| F821 Local table references NO |
| F831 Full cursor update NO |
| F831 Full cursor update 01 Updatable scrollable cursors NO |
| F831 Full cursor update 02 Updatable ordered cursors NO |
| F841 LIKE_REGEX predicate NO |
| F842 OCCURENCES_REGEX function NO |
| F843 POSITION_REGEX function NO |
| F844 SUBSTRING_REGEX function NO |
| F845 TRANSLATE_REGEX function NO |
| F846 Octet support in regular expression operators NO |
| F847 Nonconstant regular expressions NO |
| F850 Top-level <order by clause> in <query expression> YES |
| F851 <order by clause> in subqueries NO |
| F852 Top-level <order by clause> in views NO |
| F855 Nested <order by clause> in <query expression> NO |
| F856 Nested <fetch first clause> in <query expression> NO |
| F857 Top-level <fetch first clause> in <query expression> NO |
| F858 <fetch first clause> in subqueries NO |
| F859 Top-level <fetch first clause> in views NO |
| F860 <fetch first row count> in <fetch first clause> NO |
| F861 Top-level <result offset clause> in <query expression> NO |
| F862 <result offset clause> in subqueries NO |
| F863 Nested <result offset clause> in <query expression> NO |
| F864 Top-level <result offset clause> in views NO |
| F865 <offset row count> in <result offset clause> NO |
| S011 Distinct data types NO |
| S011 Distinct data types 01 USER_DEFINED_TYPES view NO |
| S023 Basic structured types NO |
| S024 Enhanced structured types NO |
| S025 Final structured types NO |
| S026 Self-referencing structured types NO |
| S027 Create method by specific method name NO |
| S028 Permutable UDT options list NO |
| S041 Basic reference types NO |
| S043 Enhanced reference types NO |
| S051 Create table of type NO |
| S071 SQL paths in function and type name resolution YES |
| S081 Subtables NO |
| S091 Basic array support NO |
| S091 Basic array support 01 Arrays of built-in data types NO |
| S091 Basic array support 02 Arrays of distinct types NO |
| S091 Basic array support 03 Array expressions NO |
| S092 Arrays of user-defined types NO |
| S094 Arrays of reference types NO |
| S095 Array constructors by query NO |
| S096 Optional array bounds NO |
| S097 Array element assignment NO |
| S098 ARRAY_AGG NO ORDER BY clause not supported |
| S111 ONLY in query expressions YES |
| S151 Type predicate NO |
| S161 Subtype treatment NO |
| S162 Subtype treatment for references NO |
| S201 SQL-invoked routines on arrays NO |
| S201 SQL-invoked routines on arrays 01 Array parameters NO |
| S201 SQL-invoked routines on arrays 02 Array as result type of functions NO |
| S202 SQL-invoked routines on multisets NO |
| S211 User-defined cast functions YES |
| S231 Structured type locators NO |
| S232 Array locators NO |
| S233 Multiset locators NO |
| S241 Transform functions NO |
| S242 Alter transform statement NO |
| S251 User-defined orderings NO |
| S261 Specific type method NO |
| S271 Basic multiset support NO |
| S272 Multisets of user-defined types NO |
| S274 Multisets of reference types NO |
| S275 Advanced multiset support NO |
| S281 Nested collection types NO |
| S291 Unique constraint on entire row NO |
| S301 Enhanced UNNEST NO |
| S401 Distinct types based on array types NO |
| S402 Distinct types based on distinct types NO |
| S403 MAX_CARDINALITY NO |
| S404 TRIM_ARRAY NO |
| T011 Timestamp in Information Schema NO |
| T021 BINARY and VARBINARY data types NO |
| T022 Advanced support for BINARY and VARBINARY data types NO |
| T023 Compound binary literal NO |
| T024 Spaces in binary literals NO |
| T031 BOOLEAN data type YES |
| T041 Basic LOB data type support NO |
| T041 Basic LOB data type support 01 BLOB data type NO |
| T041 Basic LOB data type support 02 CLOB data type NO |
| T041 Basic LOB data type support 03 POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types NO |
| T041 Basic LOB data type support 04 Concatenation of LOB data types NO |
| T041 Basic LOB data type support 05 LOB locator: non-holdable NO |
| T042 Extended LOB data type support NO |
| T043 Multiplier T NO |
| T044 Multiplier P NO |
| T051 Row types NO |
| T052 MAX and MIN for row types NO |
| T053 Explicit aliases for all-fields reference NO |
| T061 UCS support NO |
| T071 BIGINT data type YES |
| T101 Enhanced nullability determiniation NO |
| T111 Updatable joins, unions, and columns NO |
| T121 WITH (excluding RECURSIVE) in query expression NO |
| T122 WITH (excluding RECURSIVE) in subquery NO |
| T131 Recursive query NO |
| T132 Recursive query in subquery NO |
| T141 SIMILAR predicate YES |
| T151 DISTINCT predicate YES |
| T152 DISTINCT predicate with negation NO |
| T171 LIKE clause in table definition YES |
| T172 AS subquery clause in table definition YES |
| T173 Extended LIKE clause in table definition YES |
| T174 Identity columns NO |
| T175 Generated columns NO |
| T176 Sequence generator support NO |
| T177 Sequence generator support: simple restart option NO |
| T178 Identity columns: simple restart option NO |
| T191 Referential action RESTRICT NO |
| T201 Comparable data types for referential constraints NO |
| T211 Basic trigger capability NO |
| T211 Basic trigger capability 01 Triggers activated on UPDATE, INSERT, or DELETE of one base table NO |
| T211 Basic trigger capability 02 BEFORE triggers NO |
| T211 Basic trigger capability 03 AFTER triggers NO |
| T211 Basic trigger capability 04 FOR EACH ROW triggers NO |
| T211 Basic trigger capability 05 Ability to specify a search condition that must be true before the trigger is invoked NO |
| T211 Basic trigger capability 06 Support for run-time rules for the interaction of triggers and constraints NO |
| T211 Basic trigger capability 07 TRIGGER privilege YES |
| T211 Basic trigger capability 08 Multiple triggers for the same event are executed in the order in which they were created in the catalog NO intentionally omitted |
| T212 Enhanced trigger capability NO |
| T213 INSTEAD OF triggers NO |
| T231 Sensitive cursors YES |
| T241 START TRANSACTION statement YES |
| T251 SET TRANSACTION statement: LOCAL option NO |
| T261 Chained transactions NO |
| T271 Savepoints YES |
| T272 Enhanced savepoint management NO |
| T281 SELECT privilege with column granularity NO |
| T285 Enhanced derived column names NO |
| T301 Functional dependencies NO |
| T312 OVERLAY function YES |
| T321 Basic SQL-invoked routines NO |
| T321 Basic SQL-invoked routines 01 User-defined functions with no overloading YES |
| T321 Basic SQL-invoked routines 02 User-defined stored procedures with no overloading NO |
| T321 Basic SQL-invoked routines 03 Function invocation YES |
| T321 Basic SQL-invoked routines 04 CALL statement NO |
| T321 Basic SQL-invoked routines 05 RETURN statement NO |
| T321 Basic SQL-invoked routines 06 ROUTINES view YES |
| T321 Basic SQL-invoked routines 07 PARAMETERS view YES |
| T322 Overloading of SQL-invoked functions and procedures YES |
| T323 Explicit security for external routines YES |
| T324 Explicit security for SQL routines NO |
| T325 Qualified SQL parameter references NO |
| T326 Table functions NO |
| T331 Basic roles NO |
| T332 Extended roles NO |
| T351 Bracketed SQL comments (/*...*/ comments) YES |
| T431 Extended grouping capabilities NO |
| T432 Nested and concatenated GROUPING SETS NO |
| T433 Multiargument GROUPING function NO |
| T434 GROUP BY DISTINCT NO |
| T441 ABS and MOD functions YES |
| T461 Symmetric BETWEEN predicate YES |
| T471 Result sets return value NO |
| T491 LATERAL derived table NO |
| T501 Enhanced EXISTS predicate NO |
| T511 Transaction counts NO |
| T541 Updatable table references NO |
| T551 Optional key words for default syntax YES |
| T561 Holdable locators NO |
| T571 Array-returning external SQL-invoked functions NO |
| T572 Multiset-returning external SQL-invoked functions NO |
| T581 Regular expression substring function YES |
| T591 UNIQUE constraints of possibly null columns YES |
| T601 Local cursor references NO |
| T611 Elementary OLAP operations YES |
| T612 Advanced OLAP operations NO some forms supported |
| T613 Sampling NO |
| T614 NTILE function YES |
| T615 LEAD and LAG functions YES |
| T616 Null treatment option for LEAD and LAG functions NO |
| T617 FIRST_VALUE and LAST_VALUE function YES |
| T618 NTH_VALUE function NO function exists, but some options missing |
| T621 Enhanced numeric functions YES |
| T631 IN predicate with one list element NO |
| T641 Multiple column assignment NO only some syntax variants supported |
| T651 SQL-schema statements in SQL routines NO |
| T652 SQL-dynamic statements in SQL routines NO |
| T653 SQL-schema statements in external routines NO |
| T654 SQL-dynamic statements in external routines NO |
| T655 Cyclically dependent routines NO |
| M001 Datalinks NO |
| M002 Datalinks via SQL/CLI NO |
| M003 Datalinks via Embedded SQL NO |
| M004 Foreign data support NO |
| M005 Foreign schema support NO |
| M006 GetSQLString routine NO |
| M007 TransmitRequest NO |
| M009 GetOpts and GetStatistics routines NO |
| M010 Foreign data wrapper support NO |
| M011 Datalinks via Ada NO |
| M012 Datalinks via C NO |
| M013 Datalinks via COBOL NO |
| M014 Datalinks via Fortran NO |
| M015 Datalinks via M NO |
| M016 Datalinks via Pascal NO |
| M017 Datalinks via PL/I NO |
| M018 Foreign data wrapper interface routines in Ada NO |
| M019 Foreign data wrapper interface routines in C NO |
| M020 Foreign data wrapper interface routines in COBOL NO |
| M021 Foreign data wrapper interface routines in Fortran NO |
| M022 Foreign data wrapper interface routines in MUMPS NO |
| M023 Foreign data wrapper interface routines in Pascal NO |
| M024 Foreign data wrapper interface routines in PL/I NO |
| M030 SQL-server foreign data support NO |
| M031 Foreign data wrapper general routines NO |
| X010 XML type NO |
| X011 Arrays of XML type NO |
| X012 Multisets of XML type NO |
| X013 Distinct types of XML type NO |
| X014 Attributes of XML type NO |
| X015 Fields of XML type NO |
| X016 Persistent XML values NO |
| X020 XMLConcat NO |
| X025 XMLCast NO |
| X030 XMLDocument NO |
| X031 XMLElement NO |
| X032 XMLForest NO |
| X034 XMLAgg NO |
| X035 XMLAgg: ORDER BY option NO |
| X036 XMLComment NO |
| X037 XMLPI NO |
| X038 XMLText NO |
| X040 Basic table mapping NO |
| X041 Basic table mapping: nulls absent NO |
| X042 Basic table mapping: null as nil NO |
| X043 Basic table mapping: table as forest NO |
| X044 Basic table mapping: table as element NO |
| X045 Basic table mapping: with target namespace NO |
| X046 Basic table mapping: data mapping NO |
| X047 Basic table mapping: metadata mapping NO |
| X048 Basic table mapping: base64 encoding of binary strings NO |
| X049 Basic table mapping: hex encoding of binary strings NO |
| X051 Advanced table mapping: nulls absent NO |
| X052 Advanced table mapping: null as nil NO |
| X053 Advanced table mapping: table as forest NO |
| X054 Advanced table mapping: table as element NO |
| X055 Advanced table mapping: target namespace NO |
| X056 Advanced table mapping: data mapping NO |
| X057 Advanced table mapping: metadata mapping NO |
| X058 Advanced table mapping: base64 encoding of binary strings NO |
| X059 Advanced table mapping: hex encoding of binary strings NO |
| X060 XMLParse: Character string input and CONTENT option NO |
| X061 XMLParse: Character string input and DOCUMENT option NO |
| X065 XMLParse: BLOB input and CONTENT option NO |
| X066 XMLParse: BLOB input and DOCUMENT option NO |
| X068 XMLSerialize: BOM NO |
| X069 XMLSerialize: INDENT NO |
| X070 XMLSerialize: Character string serialization and CONTENT option NO |
| X071 XMLSerialize: Character string serialization and DOCUMENT option NO |
| X072 XMLSerialize: Character string serialization NO |
| X073 XMLSerialize: BLOB serialization and CONTENT option NO |
| X074 XMLSerialize: BLOB serialization and DOCUMENT option NO |
| X075 XMLSerialize: BLOB serialization NO |
| X076 XMLSerialize: VERSION NO |
| X077 XMLSerialize: explicit ENCODING option NO |
| X078 XMLSerialize: explicit XML declaration NO |
| X080 Namespaces in XML publishing NO |
| X081 Query-level XML namespace declarations NO |
| X082 XML namespace declarations in DML NO |
| X083 XML namespace declarations in DDL NO |
| X084 XML namespace declarations in compound statements NO |
| X085 Predefined namespace prefixes NO |
| X086 XML namespace declarations in XMLTable NO |
| X090 XML document predicate NO |
| X091 XML content predicate NO |
| X096 XMLExists NO |
| X100 Host language support for XML: CONTENT option NO |
| X101 Host language support for XML: DOCUMENT option NO |
| X110 Host language support for XML: VARCHAR mapping NO |
| X111 Host language support for XML: CLOB mapping NO |
| X112 Host language support for XML: BLOB mapping NO |
| X113 Host language support for XML: STRIP WHITESPACE option NO |
| X114 Host language support for XML: PRESERVE WHITESPACE option NO |
| X120 XML parameters in SQL routines NO |
| X121 XML parameters in external routines NO |
| X131 Query-level XMLBINARY clause NO |
| X132 XMLBINARY clause in DML NO |
| X133 XMLBINARY clause in DDL NO |
| X134 XMLBINARY clause in compound statements NO |
| X135 XMLBINARY clause in subqueries NO |
| X141 IS VALID predicate: data-driven case NO |
| X142 IS VALID predicate: ACCORDING TO clause NO |
| X143 IS VALID predicate: ELEMENT clause NO |
| X144 IS VALID predicate: schema location NO |
| X145 IS VALID predicate outside check constraints NO |
| X151 IS VALID predicate with DOCUMENT option NO |
| X152 IS VALID predicate with CONTENT option NO |
| X153 IS VALID predicate with SEQUENCE option NO |
| X155 IS VALID predicate: NAMESPACE without ELEMENT clause NO |
| X157 IS VALID predicate: NO NAMESPACE with ELEMENT clause NO |
| X160 Basic Information Schema for registered XML Schemas NO |
| X161 Advanced Information Schema for registered XML Schemas NO |
| X170 XML null handling options NO |
| X171 NIL ON NO CONTENT option NO |
| X181 XML(DOCUMENT(UNTYPED)) type NO |
| X182 XML(DOCUMENT(ANY)) type NO |
| X190 XML(SEQUENCE) type NO |
| X191 XML(DOCUMENT(XMLSCHEMA)) type NO |
| X192 XML(CONTENT(XMLSCHEMA)) type NO |
| X200 XMLQuery NO |
| X201 XMLQuery: RETURNING CONTENT NO |
| X202 XMLQuery: RETURNING SEQUENCE NO |
| X203 XMLQuery: passing a context item NO |
| X204 XMLQuery: initializing an XQuery variable NO |
| X205 XMLQuery: EMPTY ON EMPTY option NO |
| X206 XMLQuery: NULL ON EMPTY option NO |
| X211 XML 1.1 support NO |
| X221 XML passing mechanism BY VALUE NO |
| X222 XML passing mechanism BY REF NO |
| X231 XML(CONTENT(UNTYPED)) type NO |
| X232 XML(CONTENT(ANY)) type NO |
| X241 RETURNING CONTENT in XML publishing NO |
| X242 RETURNING SEQUENCE in XML publishing NO |
| X251 Persistent XML values of XML(DOCUMENT(UNTYPED)) type NO |
| X252 Persistent XML values of XML(DOCUMENT(ANY)) type NO |
| X253 Persistent XML values of XML(CONTENT(UNTYPED)) type NO |
| X254 Persistent XML values of XML(CONTENT(ANY)) type NO |
| X255 Persistent XML values of XML(SEQUENCE) type NO |
| X256 Persistent XML values of XML(DOCUMENT(XMLSCHEMA)) type NO |
| X257 Persistent XML values of XML(CONTENT(XMLSCHEMA)) type NO |
| X260 XML type: ELEMENT clause NO |
| X261 XML type: NAMESPACE without ELEMENT clause NO |
| X263 XML type: NO NAMESPACE with ELEMENT clause NO |
| X264 XML type: schema location NO |
| X271 XMLValidate: data-driven case NO |
| X272 XMLValidate: ACCORDING TO clause NO |
| X273 XMLValidate: ELEMENT clause NO |
| X274 XMLValidate: schema location NO |
| X281 XMLValidate: with DOCUMENT option NO |
| X282 XMLValidate with CONTENT option NO |
| X283 XMLValidate with SEQUENCE option NO |
| X284 XMLValidate NAMESPACE without ELEMENT clause NO |
| X286 XMLValidate: NO NAMESPACE with ELEMENT clause NO |
| X300 XMLTable NO |
| X301 XMLTable: derived column list option NO |
| X302 XMLTable: ordinality column option NO |
| X303 XMLTable: column default option NO |
| X304 XMLTable: passing a context item NO |
| X305 XMLTable: initializing an XQuery variable NO |
| X400 Name and identifier mapping NO |
