@@ -210,7 +210,7 @@ F261CASE expression01Simple CASEYES
210210F261CASE expression02Searched CASEYES
211211F261CASE expression03NULLIFYES
212212F261CASE expression04COALESCEYES
213- F262Extended CASE expressionNO
213+ F262Extended CASE expressionYES
214214F263Comma-separated predicates in simple CASE expressionNO
215215F271Compound character literalsYES
216216F281LIKE enhancementsYES
@@ -229,7 +229,7 @@ F311Schema definition statement05GRANT statementYES
229229F312MERGE statementNO
230230F313Enhanced MERGE statementNO
231231F321User authorizationYES
232- F341Usage tablesNO
232+ F341Usage tablesNOno ROUTINE_*_USAGE tables
233233F361Subprogram supportYES
234234F381Extended schema manipulationYES
235235F381Extended schema manipulation01ALTER TABLE statement: ALTER COLUMN clauseYES
@@ -277,12 +277,12 @@ F561Full value expressionsYES
277277F571Truth value testsYES
278278F591Derived tablesYES
279279F611Indicator data typesYES
280- F641Row and table constructorsNO
280+ F641Row and table constructorsYES
281281F651Catalog name qualifiersYES
282282F661Simple tablesYES
283283F671Subqueries in CHECKNOintentionally omitted
284284F672Retrospective check constraintsYES
285- F690Collation supportNO
285+ F690Collation supportYESbut no character set support
286286F692Enhanced collation supportNO
287287F693SQL-session and client module collationsNO
288288F695Translation supportNO
@@ -337,7 +337,7 @@ S027Create method by specific method nameNO
337337S028Permutable UDT options listNO
338338S041Basic reference typesNO
339339S043Enhanced reference typesNO
340- S051Create table of typeNO
340+ S051Create table of typeNOpartially supported
341341S071SQL paths in function and type name resolutionYES
342342S081SubtablesNO
343343S091Basic array supportNOpartially supported
@@ -435,7 +435,7 @@ T271SavepointsYES
435435T272Enhanced savepoint managementNO
436436T281SELECT privilege with column granularityYES
437437T285Enhanced derived column namesNO
438- T301Functional dependenciesNO
438+ T301Functional dependenciesNOpartially supported
439439T312OVERLAY functionYES
440440T321Basic SQL-invoked routinesNO
441441T321Basic SQL-invoked routines01User-defined functions with no overloadingYES
@@ -450,8 +450,8 @@ T323Explicit security for external routinesYES
450450T324Explicit security for SQL routinesNO
451451T325Qualified SQL parameter referencesNO
452452T326Table functionsNO
453- T331Basic rolesNO
454- T332Extended rolesNO
453+ T331Basic rolesYES
454+ T332Extended rolesNOmostly supported
455455T351Bracketed SQL comments (/*...*/ comments)YES
456456T431Extended grouping capabilitiesNO
457457T432Nested and concatenated GROUPING SETSNO
@@ -490,7 +490,7 @@ T655Cyclically dependent routinesYES
490490M001DatalinksNO
491491M002Datalinks via SQL/CLINO
492492M003Datalinks via Embedded SQLNO
493- M004Foreign data supportNO
493+ M004Foreign data supportNOpartially supported
494494M005Foreign schema supportNO
495495M006GetSQLString routineNO
496496M007TransmitRequestNO
@@ -647,4 +647,4 @@ X302XMLTable: ordinality column optionNO
647647X303XMLTable: column default optionNO
648648X304XMLTable: passing a context itemNO
649649X305XMLTable: initializing an XQuery variableNO
650- X400Name and identifier mappingNO
650+ X400Name and identifier mappingYES