4 B014 Embedded Fortran NO
6 B016 Embedded Pascal NO
9 B031 Basic dynamic SQL NO
10 B032 Extended dynamic SQL NO
11 B032 Extended dynamic SQL 01 <describe input> statement NO
12 B041 Extensions to embedded SQL exception declarations NO
13 B051 Enhanced execution rights NO
14 E011 Numeric data types YES
15 E011 Numeric data types 01 INTEGER and SMALLINT data types YES
16 E011 Numeric data types 02 REAL, DOUBLE PRECISION, and FLOAT data types YES
17 E011 Numeric data types 03 DECIMAL and NUMERIC data types YES
18 E011 Numeric data types 04 Arithmetic operators YES
19 E011 Numeric data types 05 Numeric comparison YES
20 E011 Numeric data types 06 Implicit casting among the numeric data types YES
21 E021 Character data types YES
22 E021 Character data types 01 CHARACTER data type YES
23 E021 Character data types 02 CHARACTER VARYING data type YES
24 E021 Character data types 03 Character literals YES
25 E021 Character data types 04 CHARACTER_LENGTH function YES
26 E021 Character data types 05 OCTET_LENGTH function YES
27 E021 Character data types 06 SUBSTRING function YES
28 E021 Character data types 07 Character concatenation YES
29 E021 Character data types 08 UPPER and LOWER functions YES
30 E021 Character data types 09 TRIM function YES
31 E021 Character data types 10 Implicit casting among the character data types YES
32 E021 Character data types 11 POSITION function YES
33 E021 Character data types 12 Character comparison YES
35 E031 Identifiers 01 Delimited identifiers YES
36 E031 Identifiers 02 Lower case identifiers YES
37 E031 Identifiers 03 Trailing underscore YES
38 E051 Basic query specification YES
39 E051 Basic query specification 01 SELECT DISTINCT YES
40 E051 Basic query specification 02 GROUP BY clause YES
41 E051 Basic query specification 04 GROUP BY can contain columns not in <select list> YES
42 E051 Basic query specification 05 Select list items can be renamed YES AS is required
43 E051 Basic query specification 06 HAVING clause YES
44 E051 Basic query specification 07 Qualified * in select list YES
45 E051 Basic query specification 08 Correlation names in the FROM clause YES
46 E051 Basic query specification 09 Rename columns in the FROM clause YES
47 E061 Basic predicates and search conditions YES
48 E061 Basic predicates and search conditions 01 Comparison predicate YES
49 E061 Basic predicates and search conditions 02 BETWEEN predicate YES
50 E061 Basic predicates and search conditions 03 IN predicate with list of values YES
51 E061 Basic predicates and search conditions 04 LIKE predicate YES
52 E061 Basic predicates and search conditions 05 LIKE predicate ESCAPE clause YES
53 E061 Basic predicates and search conditions 06 NULL predicate YES
54 E061 Basic predicates and search conditions 07 Quantified comparison predicate YES
55 E061 Basic predicates and search conditions 08 EXISTS predicate YES
56 E061 Basic predicates and search conditions 09 Subqueries in comparison predicate YES
57 E061 Basic predicates and search conditions 11 Subqueries in IN predicate YES
58 E061 Basic predicates and search conditions 12 Subqueries in quantified comparison predicate YES
59 E061 Basic predicates and search conditions 13 Correlated subqueries YES
60 E061 Basic predicates and search conditions 14 Search condition YES
61 E071 Basic query expressions YES
62 E071 Basic query expressions 01 UNION DISTINCT table operator YES
63 E071 Basic query expressions 02 UNION ALL table operator YES
64 E071 Basic query expressions 03 EXCEPT DISTINCT table operator YES
65 E071 Basic query expressions 05 Columns combined via table operators need not have exactly the same data type YES
66 E071 Basic query expressions 06 Table operators in subqueries YES
67 E081 Basic Privileges NO
68 E081 Basic Privileges 01 SELECT privilege YES
69 E081 Basic Privileges 02 DELETE privilege YES
70 E081 Basic Privileges 03 INSERT privilege at the table level YES
71 E081 Basic Privileges 04 UPDATE privilege at the table level YES
72 E081 Basic Privileges 05 UPDATE privilege at the column level NO
73 E081 Basic Privileges 06 REFERENCES privilege at the table level YES
74 E081 Basic Privileges 07 REFERENCES privilege at the column level NO
75 E081 Basic Privileges 08 WITH GRANT OPTION YES
76 E091 Set functions YES
77 E091 Set functions 01 AVG YES
78 E091 Set functions 02 COUNT YES
79 E091 Set functions 03 MAX YES
80 E091 Set functions 04 MIN YES
81 E091 Set functions 05 SUM YES
82 E091 Set functions 06 ALL quantifier YES
83 E091 Set functions 07 DISTINCT quantifier YES
84 E101 Basic data manipulation YES
85 E101 Basic data manipulation 01 INSERT statement YES
86 E101 Basic data manipulation 03 Searched UPDATE statement YES
87 E101 Basic data manipulation 04 Searched DELETE statement YES
88 E111 Single row SELECT statement YES
89 E121 Basic cursor support NO
90 E121 Basic cursor supoprt 01 DECLARE CURSOR YES
91 E121 Basic cursor support 02 ORDER BY columns need not be in select list YES
92 E121 Basic cursor support 03 Value expressions in ORDER BY clause YES
93 E121 Basic cursor support 04 OPEN statement YES
94 E121 Basic cursor support 06 Positioned UPDATE statement NO
95 E121 Basic cursor support 07 Positioned DELETE statement NO
96 E121 Basic cursor support 08 CLOSE statement YES
97 E121 Basic cursor support 10 FETCH statement implicit NEXT YES
98 E121 Basic cursor support 17 WITH HOLD cursors YES
99 E131 Null value support (nulls in lieu of values) YES
100 E141 Basic integrity constraints YES
101 E141 Basic integrity constraints 01 NOT NULL constraints YES
102 E141 Basic integrity constraints 02 UNIQUE constraints of NOT NULL columns YES
103 E141 Basic integrity constraints 03 PRIMARY KEY constraints YES
104 E141 Basic integrity constraints 04 Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action YES
105 E141 Basic integrity constraints 06 CHECK constraints YES
106 E141 Basic integrity constraints 07 Column defaults YES
107 E141 Basic integrity constraints 08 NOT NULL inferred on PRIMARY KEY YES
108 E141 Basic integrity constraints 10 Names in a foreign key can be specified in any order YES
109 E151 Transaction support YES
110 E151 Transaction support 01 COMMIT statement YES
111 E151 Transaction support 02 ROLLBACK statement YES
112 E152 Basic SET TRANSACTION statement YES
113 E152 Basic SET TRANSACTION statement 01 SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause YES
114 E152 Basic SET TRANSACTION statement 02 SET TRANSACTION statement: READ ONLY and READ WRITE clauses YES
115 E153 Updatable queries with subqueries NO
116 E161 SQL comments using leading double minus YES
117 E171 SQLSTATE support YES
118 E182 Module language NO
119 F021 Basic information schema YES
120 F021 Basic information schema 01 COLUMNS view YES
121 F021 Basic information schema 02 TABLES view YES
122 F021 Basic information schema 03 VIEWS view YES
123 F021 Basic information schema 04 TABLE_CONSTRAINTS view YES
124 F021 Basic information schema 05 REFERENTIAL_CONSTRAINTS view YES
125 F021 Basic information schema 06 CHECK_CONSTRAINTS view YES
126 F031 Basic schema manipulation YES
127 F031 Basic schema manipulation 01 CREATE TABLE statement to create persistent base tables YES
128 F031 Basic schema manipulation 02 CREATE VIEW statement YES
129 F031 Basic schema manipulation 03 GRANT statement YES
130 F031 Basic schema manipulation 04 ALTER TABLE statement: ADD COLUMN clause YES
131 F031 Basic schema manipulation 13 DROP TABLE statement: RESTRICT clause YES
132 F031 Basic schema manipulation 16 DROP VIEW statement: RESTRICT clause YES
133 F031 Basic schema manipulation 19 REVOKE statement: RESTRICT clause YES
134 F032 CASCADE drop behavior YES
135 F033 ALTER TABLE statement: DROP COLUMN clause YES
136 F034 Extended REVOKE statement YES
137 F034 Extended REVOKE statement 01 REVOKE statement performed by other than the owner of a schema object YES
138 F034 Extended REVOKE statement 02 REVOKE statement: GRANT OPTION FOR clause YES
139 F034 Extended REVOKE statement 03 REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION YES
140 F041 Basic joined table YES
141 F041 Basic joined table 01 Inner join (but not necessarily the INNER keyword) YES
142 F041 Basic joined table 02 INNER keyword YES
143 F041 Basic joined table 03 LEFT OUTER JOIN YES
144 F041 Basic joined table 04 RIGHT OUTER JOIN YES
145 F041 Basic joined table 05 Outer joins can be nested YES
146 F041 Basic joined table 07 The inner table in a left or right outer join can also be used in an inner join YES
147 F041 Basic joined table 08 All comparison operators are supported (rather than just =) YES
148 F051 Basic date and time YES
149 F051 Basic date and time 01 DATE data type (including support of DATE literal) YES
150 F051 Basic date and time 02 TIME data type (including support of TIME literal) with fractional seconds precision of at least 0 YES
151 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
152 F051 Basic date and time 04 Comparison predicate on DATE, TIME, and TIMESTAMP data types YES
153 F051 Basic date and time 05 Explicit CAST between datetime types and character types YES
154 F051 Basic date and time 06 CURRENT_DATE YES
155 F051 Basic date and time 07 LOCALTIME YES
156 F051 Basic date and time 08 LOCALTIMESTAMP YES
157 F052 Intervals and datetime arithmetic YES
158 F081 UNION and EXCEPT in views YES
159 F111 Isolation levels other than SERIALIZABLE NO
160 F111 Isolation levels other than SERIALIZABLE 01 READ UNCOMMITTED isolation level NO
161 F111 Isolation levels other than SERIALIZABLE 02 READ COMMITTED isolation level YES
162 F111 Isolation levels other than SERIALIZABLE 03 REPEATABLE READ isolation level NO
163 F121 Basic diagnostics management NO
164 F121 Basic diagnostics management 01 GET DIAGNOSTICS statement NO
165 F121 Basic diagnostics management 02 SET TRANSACTION statement: DIAGNOSTICS SIZE clause NO
166 F131 Grouped operations YES
167 F131 Grouped operations 01 WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views YES
168 F131 Grouped operations 02 Multiple tables supported in queries with grouped views YES
169 F131 Grouped operations 03 Set functions supported in queries with grouped views YES
170 F131 Grouped operations 04 Subqueries with GROUP BY and HAVING clauses and grouped views YES
171 F131 Grouped operations 05 Single row SELECT with GROUP BY and HAVING clauses and grouped views YES
172 F171 Multiple schemas per user YES
173 F181 Multiple module support NO
174 F191 Referential delete actions YES
175 F201 CAST function YES
176 F221 Explicit defaults YES
177 F222 INSERT statement: DEFAULT VALUES clause YES
178 F231 Privilege Tables YES
179 F231 Privilege Tables 01 TABLE_PRIVILEGES view YES
180 F231 Privilege Tables 02 COLUMN_PRIVILEGES view YES
181 F231 Privilege Tables 03 USAGE_PRIVILEGES view YES
182 F251 Domain support YES
183 F261 CASE expression YES
184 F261 CASE expression 01 Simple CASE YES
185 F261 CASE expression 02 Searched CASE YES
186 F261 CASE expression 03 NULLIF YES
187 F261 CASE expression 04 COALESCE YES
188 F271 Compound character literals YES
189 F281 LIKE enhancements YES
190 F291 UNIQUE predicate NO
191 F301 CORRESPONDING in query expressions NO
192 F302 INTERSECT table operator YES
193 F302 INTERSECT table operator 01 INTERSECT DISTINCT table operator YES
194 F302 INTERSECT table operator 02 INTERSECT ALL table operator YES
195 F304 EXCEPT ALL table operator YES
196 F311 Schema definition statement NO
197 F311 Schema definition statement 01 CREATE SCHEMA YES
198 F311 Schema definition statement 02 CREATE TABLE for persistent base tables YES
199 F311 Schema definition statement 03 CREATE VIEW YES
200 F311 Schema definition statement 04 CREATE VIEW: WITH CHECK OPTION NO
201 F311 Schema definition statement 05 GRANT statement YES
202 F321 User authorization YES
204 F361 Subprogram support YES
205 F381 Extended schema manipulation YES
206 F381 Extended schema manipulation 01 ALTER TABLE statement: ALTER COLUMN clause YES
207 F381 Extended schema manipulation 02 ALTER TABLE statement: ADD CONSTRAINT clause YES
208 F381 Extended schema manipulation 03 ALTER TABLE statement: DROP CONSTRAINT clause YES
209 F391 Long identifiers YES
210 F401 Extended joined table YES
211 F401 Extended joined table 01 NATURAL JOIN YES
212 F401 Extended joined table 02 FULL OUTER JOIN YES
213 F401 Extended joined table 03 UNION JOIN YES
214 F401 Extended joined table 04 CROSS JOIN YES
215 F411 Time zone specification YES
216 F421 National character YES
217 F431 Read-only scrollable cursors YES
218 F431 Read-only scrollable cursors 01 FETCH with explicit NEXT YES
219 F431 Read-only scrollable cursors 02 FETCH FIRST YES
220 F431 Read-only scrollable cursors 03 FETCH LAST YES
221 F431 Read-only scrollable cursors 04 FETCH PRIOR YES
222 F431 Read-only scrollable cursors 05 FETCH ABSOLUTE YES
223 F431 Read-only scrollable cursors 06 FETCH RELATIVE YES
224 F441 Extended set function support YES
225 F451 Character set definition NO
226 F461 Named character sets NO
227 F471 Scalar subquery values YES
228 F481 Expanded NULL predicate YES
229 F491 Constraint management YES
230 F501 Features and conformance views YES
231 F501 Features and conformance views 01 SQL_FEATURES view YES
232 F501 Features and conformance views 02 SQL_SIZING view YES
233 F501 Features and conformance views 03 SQL_LANGUAGES view YES
234 F502 Enhanced documentation tables YES
235 F502 Enhanced documentation tables 01 SQL_SIZING_PROFILES view YES
236 F502 Enhanced documentation tables 02 SQL_IMPLEMENTATION_INFO view YES
237 F502 Enhanced documentation tables 03 SQL_PACKAGES view YES
238 F511 BIT data type YES
240 F531 Temporary tables YES
241 F555 Enhanced seconds precision YES
242 F561 Full value expressions YES
243 F571 Truth value tests YES
244 F591 Derived tables YES
245 F611 Indicator data types YES
246 F641 Row and table constructors NO
247 F651 Catalog name qualifiers YES
248 F661 Simple tables NO
249 F671 Subqueries in CHECK NO intentionally omitted
250 F691 Collation and translation NO
251 F701 Referential update actions YES
252 F711 ALTER domain YES
253 F721 Deferrable constraints NO foreign keys only
254 F731 INSERT column privileges NO
255 F741 Referential MATCH types NO no partial match yet
256 F751 View CHECK enhancements NO
257 F761 Session management YES
258 F771 Connection management YES
259 F781 Self-referencing operations YES
260 F791 Insensitive cursors YES
261 F801 Full set function YES
262 F811 Extended flagging NO
263 F812 Basic flagging NO
264 F813 Extended flagging for "Core SQL Flagging" and "Catalog Lookup" only NO
265 F821 Local table references NO
266 F831 Full cursor update NO
267 F831 Full cursor update 01 Updatable scrollable cursors NO
268 F831 Full cursor update 02 Updatable ordered cursors NO
269 S011 Distinct data types NO
270 S011 Distinct data types 01 USER_DEFINED_TYPES view NO
271 S023 Basic structured types NO
272 S024 Enhanced structured types NO
273 S041 Basic reference types NO
274 S043 Enhanced reference types NO
275 S051 Create table of type NO
276 S071 SQL paths in function and type name resolution YES
278 S091 Basic array support NO
279 S091 Basic array support 01 Arrays of built-in data types NO
280 S091 Basic array support 02 Arrays of distinct types NO
281 S091 Basic array support 03 Array expressions NO
282 S092 Arrays of user-defined types NO
283 S094 Arrays of reference types NO
284 S111 ONLY in query expressions YES
285 S151 Type predicate NO
286 S161 Subtype treatment NO
287 S201 SQL routines on arrays NO
288 S201 SQL routines on arrays 01 Array parameters NO
289 S201 SQL routines on arrays 02 Array as result type of functions NO
290 S211 User-defined cast functions YES
291 S231 Structured type locators NO
292 S232 Array locators NO
293 S241 Transform functions NO
294 S251 User-defined orderings NO
295 S261 Specific type method NO
296 T011 Timestamp in Information Schema NO
297 T031 BOOLEAN data type YES
298 T041 Basic LOB data type support NO
299 T041 Basic LOB data type support 01 BLOB data type NO
300 T041 Basic LOB data type support 02 CLOB data type NO
301 T041 Basic LOB data type support 03 POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types NO
302 T041 Basic LOB data type support 04 Concatenation of LOB data types NO
303 T041 Basic LOB data type support 05 LOB locator: non-holdable NO
304 T042 Extended LOB data type support NO
306 T111 Updatable joins, unions, and columns NO
307 T121 WITH (excluding RECURSIVE) in query expression NO
308 T131 Recursive query NO
309 T141 SIMILAR predicate YES
310 T151 DISTINCT predicate YES
311 T171 LIKE clause in table definition YES
312 T191 Referential action RESTRICT YES
313 T201 Comparable data types for referential constraints YES
314 T211 Basic trigger capability NO
315 T211 Basic trigger capability 01 Triggers activated on UPDATE, INSERT, or DELETE of one base table YES
316 T211 Basic trigger capability 02 BEFORE triggers YES
317 T211 Basic trigger capability 03 AFTER triggers YES
318 T211 Basic trigger capability 04 FOR EACH ROW triggers YES
319 T211 Basic trigger capability 05 Ability to specify a search condition that must be true before the trigger is invoked NO
320 T211 Basic trigger capability 06 Support for run-time rules for the interaction of triggers and constraints NO
321 T211 Basic trigger capability 07 TRIGGER privilege YES
322 T211 Basic trigger capability 08 Multiple triggers for the same event are executed in the order in which they were created NO intentionally omitted
323 T212 Enhanced trigger capability YES
324 T231 SENSITIVE cursors YES
325 T241 START TRANSACTION statement YES
326 T251 SET TRANSACTION statement: LOCAL option NO
327 T261 Chained transactions NO
329 T281 SELECT privilege with column granularity NO
330 T301 Functional Dependencies NO
331 T312 OVERLAY function YES
332 T321 Basic SQL-invoked routines NO
333 T321 Basic SQL-invoked routines 01 User-defined functions with no overloading YES
334 T321 Basic SQL-invoked routines 02 User-defined stored procedures with no overloading NO
335 T321 Basic SQL-invoked routines 03 Function invocation YES
336 T321 Basic SQL-invoked routines 04 CALL statement NO
337 T321 Basic SQL-invoked routines 05 RETURN statement NO
338 T321 Basic SQL-invoked routines 06 ROUTINES view YES
339 T321 Basic SQL-invoked routines 07 PARAMETERS view YES
340 T322 Overloading of SQL-invoked functions and procedures YES
341 T323 Explicit security for external routines YES
343 T332 Extended roles NO
344 T351 Bracketed SQL comments (/*...*/ comments) YES
345 T401 INSERT into a cursor NO
346 T411 UPDATE statement: SET ROW option NO
347 T431 CUBE and ROLLUP operations NO
348 T441 ABS and MOD functions YES
349 T461 Symmetric BETWEEN predicate NO
350 T471 Result sets return value NO
351 T491 LATERAL derived table NO
352 T501 Enhanced EXISTS predicate YES
353 T511 Transaction counts NO
354 T541 Updatable table references NO
355 T551 Optional key words for default syntax YES
356 T561 Holdable locators NO
357 T571 Array-returning external SQL-invoked functions NO
358 T581 Regular expression substring function YES
359 T591 UNIQUE constraints of possibly null columns YES
360 T601 Local cursor references NO