codekingpro/portable-devtools

1B011	Embedded Ada			NO	2B012	Embedded C			YES	3B013	Embedded COBOL			NO	4B014	Embedded Fortran			NO	5B015	Embedded MUMPS			NO	6B016	Embedded Pascal			NO	7B017	Embedded PL/I			NO	8B021	Direct SQL			YES	9B030	Enhanced dynamic SQL			NO	10B031	Basic dynamic SQL			NO	11B032	Extended dynamic SQL			NO	12B033	Untyped SQL-invoked function arguments			NO	13B034	Dynamic specification of cursor attributes			NO	14B035	Non-extended descriptor names			NO	15B036	Describe input statement			NO	16B041	Extensions to embedded SQL exception declarations			NO	17B051	Enhanced execution rights			NO	18B111	Module language Ada			NO	19B112	Module language C			NO	20B113	Module language COBOL			NO	21B114	Module language Fortran			NO	22B115	Module language MUMPS			NO	23B116	Module language Pascal			NO	24B117	Module language PL/I			NO	25B121	Routine language Ada			NO	26B122	Routine language C			NO	27B123	Routine language COBOL			NO	28B124	Routine language Fortran			NO	29B125	Routine language MUMPS			NO	30B126	Routine language Pascal			NO	31B127	Routine language PL/I			NO	32B128	Routine language SQL			YES	33B200	Polymorphic table functions			NO	34B201	More than one PTF generic table parameter			NO	35B202	PTF copartitioning			NO	36B203	More than one copartition specification			NO	37B204	PRUNE WHEN EMPTY			NO	38B205	Pass-through columns			NO	39B206	PTF descriptor parameters			NO	40B207	Cross products of partitionings			NO	41B208	PTF component procedure interface			NO	42B209	PTF extended names			NO	43B211	Module language Ada: VARCHAR and NUMERIC support			NO	44B221	Routine language Ada: VARCHAR and NUMERIC support			NO	45E011	Numeric data types			YES	46E011	Numeric data types	01	INTEGER and SMALLINT data types	YES	47E011	Numeric data types	02	REAL, DOUBLE PRECISION, and FLOAT data types	YES	48E011	Numeric data types	03	DECIMAL and NUMERIC data types	YES	49E011	Numeric data types	04	Arithmetic operators	YES	50E011	Numeric data types	05	Numeric comparison	YES	51E011	Numeric data types	06	Implicit casting among the numeric data types	YES	52E021	Character data types			YES	53E021	Character string types	01	CHARACTER data type	YES	54E021	Character string types	02	CHARACTER VARYING data type	YES	55E021	Character string types	03	Character literals	YES	56E021	Character string types	04	CHARACTER_LENGTH function	YES	trims trailing spaces from CHARACTER values before counting57E021	Character string types	05	OCTET_LENGTH function	YES	58E021	Character string types	06	SUBSTRING function	YES	59E021	Character string types	07	Character concatenation	YES	60E021	Character string types	08	UPPER and LOWER functions	YES	61E021	Character string types	09	TRIM function	YES	62E021	Character string types	10	Implicit casting among the character string types	YES	63E021	Character string types	11	POSITION function	YES	64E021	Character string types	12	Character comparison	YES	65E031	Identifiers			YES	66E031	Identifiers	01	Delimited identifiers	YES	67E031	Identifiers	02	Lower case identifiers	YES	68E031	Identifiers	03	Trailing underscore	YES	69E051	Basic query specification			YES	70E051	Basic query specification	01	SELECT DISTINCT	YES	71E051	Basic query specification	02	GROUP BY clause	YES	72E051	Basic query specification	04	GROUP BY can contain columns not in <select list>	YES	73E051	Basic query specification	05	Select list items can be renamed	YES	74E051	Basic query specification	06	HAVING clause	YES	75E051	Basic query specification	07	Qualified * in select list	YES	76E051	Basic query specification	08	Correlation names in the FROM clause	YES	77E051	Basic query specification	09	Rename columns in the FROM clause	YES	78E061	Basic predicates and search conditions			YES	79E061	Basic predicates and search conditions	01	Comparison predicate	YES	80E061	Basic predicates and search conditions	02	BETWEEN predicate	YES	81E061	Basic predicates and search conditions	03	IN predicate with list of values	YES	82E061	Basic predicates and search conditions	04	LIKE predicate	YES	83E061	Basic predicates and search conditions	05	LIKE predicate ESCAPE clause	YES	84E061	Basic predicates and search conditions	06	NULL predicate	YES	85E061	Basic predicates and search conditions	07	Quantified comparison predicate	YES	86E061	Basic predicates and search conditions	08	EXISTS predicate	YES	87E061	Basic predicates and search conditions	09	Subqueries in comparison predicate	YES	88E061	Basic predicates and search conditions	11	Subqueries in IN predicate	YES	89E061	Basic predicates and search conditions	12	Subqueries in quantified comparison predicate	YES	90E061	Basic predicates and search conditions	13	Correlated subqueries	YES	91E061	Basic predicates and search conditions	14	Search condition	YES	92E071	Basic query expressions			YES	93E071	Basic query expressions	01	UNION DISTINCT table operator	YES	94E071	Basic query expressions	02	UNION ALL table operator	YES	95E071	Basic query expressions	03	EXCEPT DISTINCT table operator	YES	96E071	Basic query expressions	05	Columns combined via table operators need not have exactly the same data type	YES	97E071	Basic query expressions	06	Table operators in subqueries	YES	98E081	Basic Privileges			YES	99E081	Basic Privileges	01	SELECT privilege	YES	100E081	Basic Privileges	02	DELETE privilege	YES	101E081	Basic Privileges	03	INSERT privilege at the table level	YES	102E081	Basic Privileges	04	UPDATE privilege at the table level	YES	103E081	Basic Privileges	05	UPDATE privilege at the column level	YES	104E081	Basic Privileges	06	REFERENCES privilege at the table level	YES	105E081	Basic Privileges	07	REFERENCES privilege at the column level	YES	106E081	Basic Privileges	08	WITH GRANT OPTION	YES	107E081	Basic Privileges	09	USAGE privilege	YES	108E081	Basic Privileges	10	EXECUTE privilege	YES	109E091	Set functions			YES	110E091	Set functions	01	AVG	YES	111E091	Set functions	02	COUNT	YES	112E091	Set functions	03	MAX	YES	113E091	Set functions	04	MIN	YES	114E091	Set functions	05	SUM	YES	115E091	Set functions	06	ALL quantifier	YES	116E091	Set functions	07	DISTINCT quantifier	YES	117E101	Basic data manipulation			YES	118E101	Basic data manipulation	01	INSERT statement	YES	119E101	Basic data manipulation	03	Searched UPDATE statement	YES	120E101	Basic data manipulation	04	Searched DELETE statement	YES	121E111	Single row SELECT statement			YES	122E121	Basic cursor support			YES	123E121	Basic cursor support	01	DECLARE CURSOR	YES	124E121	Basic cursor support	02	ORDER BY columns need not be in select list	YES	125E121	Basic cursor support	03	Value expressions in ORDER BY clause	YES	126E121	Basic cursor support	04	OPEN statement	YES	127E121	Basic cursor support	06	Positioned UPDATE statement	YES	128E121	Basic cursor support	07	Positioned DELETE statement	YES	129E121	Basic cursor support	08	CLOSE statement	YES	130E121	Basic cursor support	10	FETCH statement implicit NEXT	YES	131E121	Basic cursor support	17	WITH HOLD cursors	YES	132E131	Null value support (nulls in lieu of values)			YES	133E141	Basic integrity constraints			YES	134E141	Basic integrity constraints	01	NOT NULL constraints	YES	135E141	Basic integrity constraints	02	UNIQUE constraints of NOT NULL columns	YES	136E141	Basic integrity constraints	03	PRIMARY KEY constraints	YES	137E141	Basic integrity constraints	04	Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action	YES	138E141	Basic integrity constraints	06	CHECK constraints	YES	139E141	Basic integrity constraints	07	Column defaults	YES	140E141	Basic integrity constraints	08	NOT NULL inferred on PRIMARY KEY	YES	141E141	Basic integrity constraints	10	Names in a foreign key can be specified in any order	YES	142E151	Transaction support			YES	143E151	Transaction support	01	COMMIT statement	YES	144E151	Transaction support	02	ROLLBACK statement	YES	145E152	Basic SET TRANSACTION statement			YES	146E152	Basic SET TRANSACTION statement	01	SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause	YES	147E152	Basic SET TRANSACTION statement	02	SET TRANSACTION statement: READ ONLY and READ WRITE clauses	YES	148E153	Updatable queries with subqueries			YES	149E161	SQL comments using leading double minus			YES	150E171	SQLSTATE support			YES	151E182	Host language binding			YES	152F021	Basic information schema			YES	153F021	Basic information schema	01	COLUMNS view	YES	154F021	Basic information schema	02	TABLES view	YES	155F021	Basic information schema	03	VIEWS view	YES	156F021	Basic information schema	04	TABLE_CONSTRAINTS view	YES	157F021	Basic information schema	05	REFERENTIAL_CONSTRAINTS view	YES	158F021	Basic information schema	06	CHECK_CONSTRAINTS view	YES	159F031	Basic schema manipulation			YES	160F031	Basic schema manipulation	01	CREATE TABLE statement to create persistent base tables	YES	161F031	Basic schema manipulation	02	CREATE VIEW statement	YES	162F031	Basic schema manipulation	03	GRANT statement	YES	163F031	Basic schema manipulation	04	ALTER TABLE statement: ADD COLUMN clause	YES	164F031	Basic schema manipulation	13	DROP TABLE statement: RESTRICT clause	YES	165F031	Basic schema manipulation	16	DROP VIEW statement: RESTRICT clause	YES	166F031	Basic schema manipulation	19	REVOKE statement: RESTRICT clause	YES	167F032	CASCADE drop behavior			YES	168F033	ALTER TABLE statement: DROP COLUMN clause			YES	169F034	Extended REVOKE statement			YES	170F035	REVOKE with CASCADE			YES	171F036	REVOKE statement performed by non-owner			YES	172F037	REVOKE statement: GRANT OPTION FOR clause			YES	173F038	REVOKE of a WITH GRANT OPTION privilege			YES	174F041	Basic joined table			YES	175F041	Basic joined table	01	Inner join (but not necessarily the INNER keyword)	YES	176F041	Basic joined table	02	INNER keyword	YES	177F041	Basic joined table	03	LEFT OUTER JOIN	YES	178F041	Basic joined table	04	RIGHT OUTER JOIN	YES	179F041	Basic joined table	05	Outer joins can be nested	YES	180F041	Basic joined table	07	The inner table in a left or right outer join can also be used in an inner join	YES	181F041	Basic joined table	08	All comparison operators are supported (rather than just =)	YES	182F051	Basic date and time			YES	183F051	Basic date and time	01	DATE data type (including support of DATE literal)	YES	184F051	Basic date and time	02	TIME data type (including support of TIME literal) with fractional seconds precision of at least 0	YES	185F051	Basic date and time	03	TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6	YES	186F051	Basic date and time	04	Comparison predicate on DATE, TIME, and TIMESTAMP data types	YES	187F051	Basic date and time	05	Explicit CAST between datetime types and character string types	YES	188F051	Basic date and time	06	CURRENT_DATE	YES	189F051	Basic date and time	07	LOCALTIME	YES	190F051	Basic date and time	08	LOCALTIMESTAMP	YES	191F052	Intervals and datetime arithmetic			YES	192F053	OVERLAPS predicate			YES	193F054	TIMESTAMP in DATE type precedence list			NO	194F081	UNION and EXCEPT in views			YES	195F111	Isolation levels other than SERIALIZABLE			YES	196F112	Isolation level READ UNCOMMITTED			YES	197F113	Isolation level READ COMMITTED			YES	198F114	Isolation level REPEATABLE READ			YES	199F120	Get diagnostics statement			NO	200F121	Basic diagnostics management			NO	201F122	Enhanced diagnostics management			NO	202F123	All diagnostics			NO	203F124	SET TRANSACTION statement: DIAGNOSTICS SIZE clause			NO	204F131	Grouped operations			YES	205F131	Grouped operations	01	WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views	YES	206F131	Grouped operations	02	Multiple tables supported in queries with grouped views	YES	207F131	Grouped operations	03	Set functions supported in queries with grouped views	YES	208F131	Grouped operations	04	Subqueries with GROUP BY and HAVING clauses and grouped views	YES	209F131	Grouped operations	05	Single row SELECT with GROUP BY and HAVING clauses and grouped views	YES	210F171	Multiple schemas per user			YES	211F181	Multiple module support			YES	212F191	Referential delete actions			YES	213F200	TRUNCATE TABLE statement			YES	214F201	CAST function			YES	215F202	TRUNCATE TABLE: identity column restart option			YES	216F221	Explicit defaults			YES	217F222	INSERT statement: DEFAULT VALUES clause			YES	218F231	Privilege tables			YES	219F251	Domain support			YES	220F261	CASE expression			YES	221F261	CASE expression	01	Simple CASE	YES	222F261	CASE expression	02	Searched CASE	YES	223F261	CASE expression	03	NULLIF	YES	224F261	CASE expression	04	COALESCE	YES	225F262	Extended CASE expression			YES	226F263	Comma-separated predicates in simple CASE expression			NO	227F271	Compound character literals			YES	228F281	LIKE enhancements			YES	229F291	UNIQUE predicate			NO	230F292	UNIQUE null treatment			YES	231F301	CORRESPONDING in query expressions			NO	232F302	INTERSECT table operator			YES	233F303	INTERSECT DISTINCT table operator			YES	234F304	EXCEPT ALL table operator			YES	235F305	INTERSECT ALL table operator			YES	236F311	Schema definition statement			YES	237F311	Schema definition statement	01	CREATE SCHEMA	YES	238F311	Schema definition statement	02	CREATE TABLE for persistent base tables	YES	239F311	Schema definition statement	03	CREATE VIEW	YES	240F311	Schema definition statement	04	CREATE VIEW: WITH CHECK OPTION	YES	241F311	Schema definition statement	05	GRANT statement	YES	242F312	MERGE statement			YES	243F313	Enhanced MERGE statement			YES	244F314	MERGE statement with DELETE branch			YES	245F321	User authorization			YES	246F341	Usage tables			YES	247F361	Subprogram support			YES	248F381	Extended schema manipulation			YES	249F382	Alter column data type			YES	250F383	Set column not null clause			YES	251F384	Drop identity property clause			YES	252F385	Drop column generation expression clause			YES	253F386	Set identity column generation clause			YES	254F387	ALTER TABLE statement: ALTER COLUMN clause			YES	255F388	ALTER TABLE statement: ADD/DROP CONSTRAINT clause			YES	256F391	Long identifiers			YES	257F392	Unicode escapes in identifiers			YES	258F393	Unicode escapes in literals			YES	259F394	Optional normal form specification			YES	260F401	Extended joined table			YES	261F402	Named column joins for LOBs, arrays, and multisets			YES	262F403	Partitioned join tables			NO	263F404	Range variable for common column names			YES	264F405	NATURAL JOIN			YES	265F406	FULL OUTER JOIN			YES	266F407	CROSS JOIN			YES	267F411	Time zone specification			YES	differences regarding literal interpretation268F421	National character			YES	269F431	Read-only scrollable cursors			YES	270F432	FETCH with explicit NEXT			YES	271F433	FETCH FIRST			YES	272F434	FETCH LAST			YES	273F435	FETCH PRIOR			YES	274F436	FETCH ABSOLUTE			YES	275F437	FETCH RELATIVE			YES	276F438	Scrollable cursors			YES	277F441	Extended set function support			YES	278F442	Mixed column references in set functions			YES	279F451	Character set definition			NO	280F461	Named character sets			NO	281F471	Scalar subquery values			YES	282F481	Expanded NULL predicate			YES	283F491	Constraint management			YES	284F492	Optional table constraint enforcement			NO	285F501	Features and conformance views			YES	286F501	Features and conformance views	01	SQL_FEATURES view	YES	287F501	Features and conformance views	02	SQL_SIZING view	YES	288F502	Enhanced documentation tables			YES	289F521	Assertions			NO	290F531	Temporary tables			YES	291F555	Enhanced seconds precision			YES	292F561	Full value expressions			YES	293F571	Truth value tests			YES	294F591	Derived tables			YES	295F611	Indicator data types			YES	296F641	Row and table constructors			YES	297F651	Catalog name qualifiers			YES	298F661	Simple tables			YES	299F671	Subqueries in CHECK constraints			NO	intentionally omitted300F672	Retrospective CHECK constraints			YES	301F673	Reads SQL-data routine invocations in CHECK constraints			NO	302F690	Collation support			YES	303F692	Extended collation support			YES	304F693	SQL-session and client module collations			NO	305F695	Translation support			NO	306F696	Additional translation documentation			NO	307F701	Referential update actions			YES	308F711	ALTER domain			YES	309F721	Deferrable constraints			NO	foreign and unique keys only310F731	INSERT column privileges			YES	311F741	Referential MATCH types			NO	no partial match yet312F751	View CHECK enhancements			YES	313F761	Session management			YES	314F762	CURRENT_CATALOG			YES	315F763	CURRENT_SCHEMA			YES	316F771	Connection management			YES	317F781	Self-referencing operations			YES	318F791	Insensitive cursors			YES	319F801	Full set function			YES	320F812	Basic flagging			NO	321F813	Extended flagging			NO	322F821	Local table references			NO	323F831	Full cursor update			NO	324F832	Updatable scrollable cursors			NO	325F833	Updatable ordered cursors			NO	326F841	LIKE_REGEX predicate			NO	consider regexp_like()327F842	OCCURRENCES_REGEX function			NO	consider regexp_matches()328F843	POSITION_REGEX function			NO	consider regexp_instr()329F844	SUBSTRING_REGEX function			NO	consider regexp_substr()330F845	TRANSLATE_REGEX function			NO	consider regexp_replace()331F846	Octet support in regular expression operators			NO	332F847	Non-constant regular expressions			NO	333F850	Top-level ORDER BY in query expression			YES	334F851	ORDER BY in subqueries			YES	335F852	Top-level ORDER BY in views			YES	336F855	Nested ORDER BY in query expression			YES	337F856	Nested FETCH FIRST in query expression			YES	338F857	Top-level FETCH FIRST in query expression			YES	339F858	FETCH FIRST in subqueries			YES	340F859	Top-level FETCH FIRST in views			YES	341F860	Dynamic FETCH FIRST row count			YES	342F861	Top-level OFFSET in query expression			YES	343F862	OFFSET in subqueries			YES	344F863	Nested OFFSET in query expression			YES	345F864	Top-level OFFSET in views			YES	346F865	Dynamic offset row count in OFFSET			YES	347F866	FETCH FIRST clause: PERCENT option			NO	348F867	FETCH FIRST clause: WITH TIES option			YES	349F868	ORDER BY in grouped table			YES	350F869	SQL implementation info population			YES	351R010	Row pattern recognition: FROM clause			NO	352R020	Row pattern recognition: WINDOW clause			NO	353R030	Row pattern recognition: full aggregate support			NO	354S011	Distinct data types			NO	355S011	Distinct data types	01	USER_DEFINED_TYPES view	NO	356S023	Basic structured types			NO	357S024	Enhanced structured types			NO	358S025	Final structured types			NO	359S026	Self-referencing structured types			NO	360S027	Create method by specific method name			NO	361S028	Permutable UDT options list			NO	362S041	Basic reference types			NO	363S043	Enhanced reference types			NO	364S051	Create table of type			NO	partially supported365S071	SQL paths in function and type name resolution			YES	366S081	Subtables			NO	367S090	Minimal array support			YES	368S091	Basic array support			NO	partially supported369S092	Arrays of user-defined types			YES	370S093	Arrays of distinct types			NO	371S094	Arrays of reference types			NO	372S095	Array constructors by query			YES	373S096	Optional array bounds			YES	374S097	Array element assignment			NO	375S098	ARRAY_AGG			YES	376S099	Array expressions			YES	377S111	ONLY in query expressions			YES	378S151	Type predicate			NO	see pg_typeof()379S161	Subtype treatment			NO	380S162	Subtype treatment for references			NO	381S201	SQL-invoked routines on arrays			YES	382S202	SQL-invoked routines on multisets			NO	383S203	Array parameters			YES	384S204	Array as result type of functions			YES	385S211	User-defined cast functions			YES	386S231	Structured type locators			NO	387S232	Array locators			NO	388S233	Multiset locators			NO	389S241	Transform functions			NO	390S242	Alter transform statement			NO	391S251	User-defined orderings			NO	392S261	Specific type method			NO	393S271	Basic multiset support			NO	394S272	Multisets of user-defined types			NO	395S274	Multisets of reference types			NO	396S275	Advanced multiset support			NO	397S281	Nested collection types			NO	398S291	Unique constraint on entire row			NO	399S301	Enhanced UNNEST			YES	400S401	Distinct types based on array types			NO	401S402	Distinct types based on multiset types			NO	402S403	ARRAY_MAX_CARDINALITY			NO	403S404	TRIM_ARRAY			YES	404T011	Timestamp in Information Schema			NO	405T021	BINARY and VARBINARY data types			NO	406T022	Advanced support for BINARY and VARBINARY data types			NO	407T023	Compound binary literals			NO	408T024	Spaces in binary literals			NO	409T031	BOOLEAN data type			YES	410T039	CLOB locator: non-holdable			NO	411T040	Concatenation of CLOBs			NO	412T041	Basic LOB data type support			NO	413T042	Extended LOB data type support			NO	414T043	Multiplier T			NO	415T044	Multiplier P			NO	416T045	BLOB data type			NO	417T046	CLOB data type			NO	418T047	POSITION, OCTET_LENGTH, TRIM, and SUBSTRING for BLOBs			NO	419T048	Concatenation of BLOBs			NO	420T049	BLOB locator: non-holdable			NO	421T050	POSITION, CHAR_LENGTH, OCTET_LENGTH, LOWER, TRIM, UPPER, and SUBSTRING for CLOBs			NO	422T051	Row types			NO	423T053	Explicit aliases for all-fields reference			NO	424T054	GREATEST and LEAST			YES	different null handling425T055	String padding functions			YES	426T056	Multi-character TRIM functions			YES	427T061	UCS support			YES	428T062	Character length units			NO	429T071	BIGINT data type			YES	430T076	DECFLOAT data type			NO	431T081	Optional string types maximum length			YES	432T101	Enhanced nullability determination			NO	433T111	Updatable joins, unions, and columns			NO	434T121	WITH (excluding RECURSIVE) in query expression			YES	435T122	WITH (excluding RECURSIVE) in subquery			YES	436T131	Recursive query			YES	437T132	Recursive query in subquery			YES	438T133	Enhanced cycle mark values			YES	439T141	SIMILAR predicate			YES	440T151	DISTINCT predicate			YES	441T152	DISTINCT predicate with negation			YES	442T171	LIKE clause in table definition			YES	443T172	AS subquery clause in table definition			YES	444T173	Extended LIKE clause in table definition			YES	445T174	Identity columns			YES	446T175	Generated columns			NO	mostly supported447T176	Sequence generator support			NO	supported except for NEXT VALUE FOR448T177	Sequence generator support: simple restart option			YES	449T178	Identity columns: simple restart option			YES	450T180	System-versioned tables			NO	451T181	Application-time period tables			NO	452T191	Referential action RESTRICT			YES	453T200	Trigger DDL			NO	similar but not fully compatible454T201	Comparable data types for referential constraints			YES	455T211	Basic trigger capability			NO	456T212	Enhanced trigger capability			YES	457T213	INSTEAD OF triggers			YES	458T214	BEFORE triggers			YES	459T215	AFTER triggers			YES	460T216	Ability to require true search condition before trigger is invoked			YES	461T217	TRIGGER privilege			YES	462T218	Multiple triggers for the same event executed in the order created			NO	intentionally omitted463T231	Sensitive cursors			NO	464T241	START TRANSACTION statement			YES	465T251	SET TRANSACTION statement: LOCAL option			NO	466T261	Chained transactions			YES	467T262	Multiple server transactions			NO	468T271	Savepoints			YES	469T272	Enhanced savepoint management			NO	470T281	SELECT privilege with column granularity			YES	471T285	Enhanced derived column names			YES	472T301	Functional dependencies			NO	partially supported473T312	OVERLAY function			YES	474T321	Basic SQL-invoked routines			NO	partially supported475T321	Basic SQL-invoked routines	01	User-defined functions with no overloading	YES	476T321	Basic SQL-invoked routines	02	User-defined stored procedures with no overloading	YES	477T321	Basic SQL-invoked routines	03	Function invocation	YES	478T321	Basic SQL-invoked routines	04	CALL statement	YES	479T321	Basic SQL-invoked routines	05	RETURN statement	YES	480T321	Basic SQL-invoked routines	06	ROUTINES view	YES	481T321	Basic SQL-invoked routines	07	PARAMETERS view	YES	482T322	Declared data type attributes			NO	483T323	Explicit security for external routines			YES	484T324	Explicit security for SQL routines			NO	485T325	Qualified SQL parameter references			YES	486T326	Table functions			NO	487T331	Basic roles			YES	488T332	Extended roles			YES	489T341	Overloading of SQL-invoked functions and SQL-invoked procedures			YES	490T351	Bracketed comments			YES	491T431	Extended grouping capabilities			YES	492T432	Nested and concatenated GROUPING SETS			YES	493T433	Multi-argument GROUPING function			YES	494T434	GROUP BY DISTINCT			YES	495T441	ABS and MOD functions			YES	496T461	Symmetric BETWEEN predicate			YES	497T471	Result sets return value			NO	498T472	DESCRIBE CURSOR			NO	499T491	LATERAL derived table			YES	500T495	Combined data change and retrieval			NO	different syntax501T501	Enhanced EXISTS predicate			YES	502T502	Period predicates			NO	503T511	Transaction counts			NO	504T521	Named arguments in CALL statement			YES	505T522	Default values for IN parameters of SQL-invoked procedures			NO	supported except DEFAULT key word in invocation506T523	Default values for INOUT parameters of SQL-invoked procedures			YES	507T524	Named arguments in routine invocations other than a CALL statement			YES	508T525	Default values for parameters of SQL-invoked functions			YES	509T551	Optional key words for default syntax			YES	510T561	Holdable locators			NO	511T571	Array-returning external SQL-invoked functions			NO	512T572	Multiset-returning external SQL-invoked functions			NO	513T581	Regular expression substring function			YES	514T591	UNIQUE constraints of possibly null columns			YES	515T601	Local cursor references			NO	516T611	Elementary OLAP operations			YES	517T612	Advanced OLAP operations			YES	518T613	Sampling			YES	519T614	NTILE function			YES	520T615	LEAD and LAG functions			YES	521T616	Null treatment option for LEAD and LAG functions			NO	522T617	FIRST_VALUE and LAST_VALUE functions			YES	523T618	NTH_VALUE function			NO	function exists, but some options missing524T619	Nested window functions			NO	525T620	WINDOW clause: GROUPS option			YES	526T621	Enhanced numeric functions			YES	527T622	Trigonometric functions			YES	528T623	General logarithm functions			YES	529T624	Common logarithm functions			YES	530T625	LISTAGG			NO	531T626	ANY_VALUE			YES	532T627	Window framed COUNT DISTINCT			YES	533T631	IN predicate with one list element			YES	534T641	Multiple column assignment			NO	only some syntax variants supported535T651	SQL-schema statements in SQL routines			YES	536T652	SQL-dynamic statements in SQL routines			NO	537T653	SQL-schema statements in external routines			YES	538T654	SQL-dynamic statements in external routines			NO	539T655	Cyclically dependent routines			YES	540T661	Non-decimal integer literals			YES	541T662	Underscores in numeric literals			YES	542T670	Schema and data statement mixing			YES	543T801	JSON data type			NO	544T802	Enhanced JSON data type			NO	545T803	String-based JSON			YES	546T811	Basic SQL/JSON constructor functions			YES	547T812	SQL/JSON: JSON_OBJECTAGG			YES	548T813	SQL/JSON: JSON_ARRAYAGG with ORDER BY			YES	549T814	Colon in JSON_OBJECT or JSON_OBJECTAGG			YES	550T821	Basic SQL/JSON query operators			NO	551T822	SQL/JSON: IS JSON WITH UNIQUE KEYS predicate			YES	552T823	SQL/JSON: PASSING clause			NO	553T824	JSON_TABLE: specific PLAN clause			NO	554T825	SQL/JSON: ON EMPTY and ON ERROR clauses			NO	555T826	General value expression in ON ERROR or ON EMPTY clauses			NO	556T827	JSON_TABLE: sibling NESTED COLUMNS clauses			NO	557T828	JSON_QUERY			NO	558T829	JSON_QUERY: array wrapper options			NO	559T830	Enforcing unique keys in SQL/JSON constructor functions			YES	560T831	SQL/JSON path language: strict mode			YES	561T832	SQL/JSON path language: item method			YES	562T833	SQL/JSON path language: multiple subscripts			YES	563T834	SQL/JSON path language: wildcard member accessor			YES	564T835	SQL/JSON path language: filter expressions			YES	565T836	SQL/JSON path language: starts with predicate			YES	566T837	SQL/JSON path language: regex_like predicate			YES	567T838	JSON_TABLE: PLAN DEFAULT clause			NO	568T839	Formatted cast of datetimes to/from character strings			NO	569T840	Hex integer literals in SQL/JSON path language			YES	570T851	SQL/JSON: optional keywords for default syntax			YES	571T860	SQL/JSON simplified accessor: column reference only			NO	572T861	SQL/JSON simplified accessor: case-sensitive JSON member accessor			NO	573T862	SQL/JSON simplified accessor: wildcard member accessor			NO	574T863	SQL/JSON simplified accessor: single-quoted string literal as member accessor			NO	575T864	SQL/JSON simplified accessor			NO	576T865	SQL/JSON item method: bigint()			NO	577T866	SQL/JSON item method: boolean()			NO	578T867	SQL/JSON item method: date()			NO	579T868	SQL/JSON item method: decimal()			NO	580T869	SQL/JSON item method: decimal() with precision and scale			NO	581T870	SQL/JSON item method: integer()			NO	582T871	SQL/JSON item method: number()			NO	583T872	SQL/JSON item method: string()			NO	584T873	SQL/JSON item method: time()			NO	585T874	SQL/JSON item method: time_tz()			NO	586T875	SQL/JSON item method: time precision			NO	587T876	SQL/JSON item method: timestamp()			NO	588T877	SQL/JSON item method: timestamp_tz()			NO	589T878	SQL/JSON item method: timestamp precision			NO	590T879	JSON in equality operations			YES	with jsonb591T880	JSON in grouping operations			YES	with jsonb592T881	JSON in ordering operations			NO	with jsonb, partially supported593T882	JSON in multiset element grouping operations			NO	594M001	Datalinks			NO	595M002	Datalinks via SQL/CLI			NO	596M003	Datalinks via Embedded SQL			NO	597M004	Foreign data support			NO	partially supported598M005	Foreign schema support			NO	599M006	GetSQLString routine			NO	600M007	TransmitRequest			NO	601M009	GetOpts and GetStatistics routines			NO	602M010	Foreign-data wrapper support			NO	different API603M011	Datalinks via Ada			NO	604M012	Datalinks via C			NO	605M013	Datalinks via COBOL			NO	606M014	Datalinks via Fortran			NO	607M015	Datalinks via M			NO	608M016	Datalinks via Pascal			NO	609M017	Datalinks via PL/I			NO	610M018	Foreign-data wrapper interface routines in Ada			NO	611M019	Foreign-data wrapper interface routines in C			NO	different API612M020	Foreign-data wrapper interface routines in COBOL			NO	613M021	Foreign-data wrapper interface routines in Fortran			NO	614M022	Foreign-data wrapper interface routines in MUMPS			NO	615M023	Foreign-data wrapper interface routines in Pascal			NO	616M024	Foreign-data wrapper interface routines in PL/I			NO	617M030	SQL-server foreign data support			NO	618M031	Foreign-data wrapper general routines			NO	619X010	XML type			YES	620X011	Arrays of XML type			YES	621X012	Multisets of XML type			NO	622X013	Distinct types of XML type			NO	623X014	Attributes of XML type			YES	624X015	Fields of XML type			NO	625X016	Persistent XML values			YES	626X020	XMLConcat			YES	627X025	XMLCast			NO	628X030	XMLDocument			NO	629X031	XMLElement			YES	630X032	XMLForest			YES	631X034	XMLAgg			YES	632X035	XMLAgg: ORDER BY option			YES	633X036	XMLComment			YES	634X037	XMLPI			YES	635X038	XMLText			NO	636X040	Basic table mapping			YES	637X041	Basic table mapping: null absent			YES	638X042	Basic table mapping: null as nil			YES	639X043	Basic table mapping: table as forest			YES	640X044	Basic table mapping: table as element			YES	641X045	Basic table mapping: with target namespace			YES	642X046	Basic table mapping: data mapping			YES	643X047	Basic table mapping: metadata mapping			YES	644X048	Basic table mapping: base64 encoding of binary strings			YES	645X049	Basic table mapping: hex encoding of binary strings			YES	646X050	Advanced table mapping			YES	647X051	Advanced table mapping: null absent			YES	648X052	Advanced table mapping: null as nil			YES	649X053	Advanced table mapping: table as forest			YES	650X054	Advanced table mapping: table as element			YES	651X055	Advanced table mapping: with target namespace			YES	652X056	Advanced table mapping: data mapping			YES	653X057	Advanced table mapping: metadata mapping			YES	654X058	Advanced table mapping: base64 encoding of binary strings			YES	655X059	Advanced table mapping: hex encoding of binary strings			YES	656X060	XMLParse: character string input and CONTENT option			YES	657X061	XMLParse: character string input and DOCUMENT option			YES	658X065	XMLParse: binary string input and CONTENT option			NO	659X066	XMLParse: binary string input and DOCUMENT option			NO	660X068	XMLSerialize: BOM			NO	661X069	XMLSerialize: INDENT			YES	662X070	XMLSerialize: character string serialization and CONTENT option			YES	663X071	XMLSerialize: character string serialization and DOCUMENT option			YES	664X072	XMLSerialize: character string serialization			YES	665X073	XMLSerialize: binary string serialization and CONTENT option			NO	666X074	XMLSerialize: binary string serialization and DOCUMENT option			NO	667X075	XMLSerialize: binary string serialization			NO	668X076	XMLSerialize: VERSION			NO	669X077	XMLSerialize: explicit ENCODING option			NO	670X078	XMLSerialize: explicit XML declaration			NO	671X080	Namespaces in XML publishing			NO	672X081	Query-level XML namespace declarations			NO	673X082	XML namespace declarations in DML			NO	674X083	XML namespace declarations in DDL			NO	675X084	XML namespace declarations in compound statements			NO	676X085	Predefined namespace prefixes			NO	677X086	XML namespace declarations in XMLTable			NO	678X090	XML document predicate			YES	679X091	XML content predicate			NO	680X096	XMLExists			NO	XPath 1.0 only681X100	Host language support for XML: CONTENT option			NO	682X101	Host language support for XML: DOCUMENT option			NO	683X110	Host language support for XML: VARCHAR mapping			NO	684X111	Host language support for XML: CLOB mapping			NO	685X112	Host language support for XML: BLOB mapping			NO	686X113	Host language support for XML: STRIP WHITESPACE option			NO	687X114	Host language support for XML: PRESERVE WHITESPACE option			NO	688X120	XML parameters in SQL routines			YES	689X121	XML parameters in external routines			YES	690X131	Query-level XMLBINARY clause			NO	691X132	XMLBINARY clause in DML			NO	692X133	XMLBINARY clause in DDL			NO	693X134	XMLBINARY clause in compound statements			NO	694X135	XMLBINARY clause in subqueries			NO	695X141	IS VALID predicate: data-driven case			NO	696X142	IS VALID predicate: ACCORDING TO clause			NO	697X143	IS VALID predicate: ELEMENT clause			NO	698X144	IS VALID predicate: schema location			NO	699X145	IS VALID predicate outside check constraints			NO	700X151	IS VALID predicate: with DOCUMENT option			NO	701X152	IS VALID predicate: with CONTENT option			NO	702X153	IS VALID predicate: with SEQUENCE option			NO	703X155	IS VALID predicate: NAMESPACE without ELEMENT clause			NO	704X157	IS VALID predicate: NO NAMESPACE with ELEMENT clause			NO	705X160	Basic Information Schema for registered XML schemas			NO	706X161	Advanced Information Schema for registered XML schemas			NO	707X170	XML null handling options			NO	708X171	NIL ON NO CONTENT option			NO	709X181	XML(DOCUMENT(UNTYPED)) type			NO	710X182	XML(DOCUMENT(ANY)) type			NO	711X190	XML(SEQUENCE) type			NO	712X191	XML(DOCUMENT(XMLSCHEMA)) type			NO	713X192	XML(CONTENT(XMLSCHEMA)) type			NO	714X200	XMLQuery			NO	715X201	XMLQuery: RETURNING CONTENT			NO	716X202	XMLQuery: RETURNING SEQUENCE			NO	717X203	XMLQuery: passing a context item			NO	718X204	XMLQuery: initializing an XQuery variable			NO	719X205	XMLQuery: EMPTY ON EMPTY option			NO	720X206	XMLQuery: NULL ON EMPTY option			NO	721X211	XML 1.1 support			NO	722X221	XML passing mechanism BY VALUE			YES	723X222	XML passing mechanism BY REF			NO	parser accepts BY REF but ignores it; passing is always BY VALUE724X231	XML(CONTENT(UNTYPED)) type			NO	725X232	XML(CONTENT(ANY)) type			NO	726X241	RETURNING CONTENT in XML publishing			NO	727X242	RETURNING SEQUENCE in XML publishing			NO	728X251	Persistent XML values of XML(DOCUMENT(UNTYPED)) type			NO	729X252	Persistent XML values of XML(DOCUMENT(ANY)) type			NO	730X253	Persistent XML values of XML(CONTENT(UNTYPED)) type			NO	731X254	Persistent XML values of XML(CONTENT(ANY)) type			NO	732X255	Persistent XML values of XML(SEQUENCE) type			NO	733X256	Persistent XML values of XML(DOCUMENT(XMLSCHEMA)) type			NO	734X257	Persistent XML values of XML(CONTENT(XMLSCHEMA)) type			NO	735X260	XML type: ELEMENT clause			NO	736X261	XML type: NAMESPACE without ELEMENT clause			NO	737X263	XML type: NO NAMESPACE with ELEMENT clause			NO	738X264	XML type: schema location			NO	739X271	XMLValidate: data-driven case			NO	740X272	XMLValidate: ACCORDING TO clause			NO	741X273	XMLValidate: ELEMENT clause			NO	742X274	XMLValidate: schema location			NO	743X281	XMLValidate with DOCUMENT option			NO	744X282	XMLValidate with CONTENT option			NO	745X283	XMLValidate with SEQUENCE option			NO	746X284	XMLValidate: NAMESPACE without ELEMENT clause			NO	747X286	XMLValidate: NO NAMESPACE with ELEMENT clause			NO	748X300	XMLTable			NO	XPath 1.0 only749X301	XMLTable: derived column list option			YES	750X302	XMLTable: ordinality column option			YES	751X303	XMLTable: column default option			YES	752X304	XMLTable: passing a context item			YES	must be XML DOCUMENT753X305	XMLTable: initializing an XQuery variable			NO	754X400	Name and identifier mapping			YES	755X410	Alter column data type: XML type			YES	756