| Feature ID | Feature Name |
|---|
| B011 | Embedded Ada *) |
| B012 | Embedded C *) |
| B013 | Embedded COBOL *) |
| B014 | Embedded Fortran *) |
| B015 | Embedded MUMPS *) |
| B016 | Embedded Pascal *) |
| B017 | Embedded PL/I 1 *) |
| E011 | Numeric data types |
| E011-01 | INTEGER and SMALLINT data types (including all spellings) |
| E011-02 | REAL, DOUBLE PRECISON, and FLOAT data types |
| E011-03 | DECIMAL and NUMERIC data types |
| E011-04 | Arithmetic operators |
| E011-05 | Numeric comparison |
| E011-06 | Implicit casting among the numeric data types |
| E021 | Character data types |
| E021-01 | CHARACTER data type (including all its spellings) |
| E021-02 | CHARACTER VARYING data type (including all its spellings) |
| E021-03 | Character literals |
| E021-04 | CHARACTER_LENGTH function |
| E021-05 | OCTET_LENGTH function |
| E021-06 | SUBSTRING function |
| E021-07 | Character concatenation |
| E021-08 | UPPER and LOWER functions |
| E021-09 | TRIM function |
| E021-10 | Implicit casting among the character data types |
| E021-11 | POSITION function |
| E011-12 | Character comparison |
| E031 | Identifiers |
| E031-01 | Delimited identifiers |
| E031-02 | Lower case identifiers |
| E031-03 | Trailing underscore |
| E051 | Basic query specification |
| E051-01 | SELECT DISTINCT |
| E051-02 | GROUP BY clause |
| E051-04 | GROUP BY can contain columns not in select-list |
| E051-05 | Select list items can be renamed |
| E051-06 | HAVING clause |
| E051-07 | Qualified * in select list |
| E051-08 | Correlation names in the FROM clause |
| E051-09 | Rename columns in the FROM clause |
| E061 | Basic predicates and search conditions |
| E061-01 | Comparison predicate |
| E061-02 | BETWEEN predicate |
| E061-03 | IN predicate with list of values |
| E061-04 | LIKE predicate |
| E061-05 | LIKE predicate: ESCAPE clause |
| E061-06 | NULL predicate |
| E061-07 | Quantified comparison predicate |
| E061-08 | EXISTS predicate |
| E061-09 | Subqueries in comparison predicate |
| E061-11 | Subqueries in IN predicate |
| E061-12 | Subqueries in quantified comparison predicate |
| E061-13 | Correlated subqueries |
| E061-14 | Search condition |
| E071 | Basic query expressions |
| E071-01 | UNION DISTINCT table operator |
| E071-02 | UNION ALL table operator |
| E071-03 | EXCEPT DISTINCT table operator |
| E071-05 | Columns combined via table operators need not have exactly the same data type |
| E071-06 | Table operators in subqueries |
| E081 | Basic Privileges |
| E081-01 | SELECT privilege at the table level |
| E081-02 | DELETE privilege |
| E081-03 | INSERT privilege at the table level |
| E081-04 | UPDATE privilege at the table level |
| E081-05 | UPDATE privilege at the column level |
| E081-06 | REFERENCES privilege at the table level |
| E081-07 | REFERENCES privilege at the column level |
| E081-08 | WITH GRANT OPTION |
| E081-09 | USAGE privilege |
| E081-10 | EXECUTE privilege |
| E091 | Set functions |
| E091-01 | AVG |
| E091-02 | COUNT |
| E091-03 | MAX |
| E091-04 | MIN |
| E091-05 | SUM |
| E091-06 | ALL quantifier |
| E091-07 | DISTINCT quantifier |
| E101 | Basic data manipulation |
| E101-01 | INSERT statement |
| E101-03 | Searched UPDATE statement |
| E101-04 | Searched DELETE statement |
| E111 | Single row SELECT statement |
| E121 | Basic cursor support |
| E121-01 | DECLARE CURSOR |
| E121-02 | ORDER BY columns need not be in select list |
| E121-03 | Value expressions in ORDER BY clause |
| E121-04 | OPEN statement |
| E121-06 | Positioned UPDATE statement |
| E121-07 | Positioned DELETE statement |
| E121-08 | CLOSE statement |
| E121-10 | FETCH statement: implicit NEXT |
| E121-17 | WITH HOLD cursors |
| E131 | Null value support (nulls in lieu of values) |
| E141 | Basic integrity constraints |
| E141-01 | NOT NULL constraints |
| E141-02 | UNIQUE constraints of NOT NULL columns |
| E141-03 | PRIMARY KEY constraints |
| E141-04 | Basic FOREIGN KEY constraint with the NO ACTION default |
| E141-06 | CHECK constraints |
| E141-07 | Column defaults |
| E141-08 | NOT NULL inferred on PRIMARY KEY |
| E141-10 | Names in a foreign key can be specified in any order |
| E151 | Transaction support |
| E151-01 | COMMIT statement |
| E151-02 | ROLLBACK statement |
| E152 | Basic SET TRANSACTION statement |
| E152-01 | SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause |
| E152-02 | SET TRANSACTION statement: READ ONLY and READ WRITE clauses |
| E153 | Updatable queries with subqueries |
| E161 | SQL comments using leading double minus |
| E171 | SQLSTATE support |
| F021 | Basic information schema |
| F021-01 | COLUMNS view |
| F021-02 | TABLES view |
| F021-03 | VIEWS view |
| F021-04 | TABLE_CONSTRAINTS view |
| F021-05 | REFERENTIAL_CONSTRAINTS view |
| F021-06 | CHECK_CONSTRAINTS view |
| F031 | Basic schema manipulation |
| F031-01 | CREATE TABLE statement to create persistent base tables |
| F031-02 | CREATE VIEW statement |
| F031-03 | GRANT statement |
| F031-04 | ALTER TABLE statement: ADD COLUMN clause |
| F031-13 | DROP TABLE statement: RESTRICT clause |
| F031-16 | DROP VIEW statement: RESTRICT clause |
| F031-19 | REVOKE statement: RESTRICT clause |
| F041 | Basic joined table |
| F041-01 | Inner join (but not necessarily the INNER keyword) |
| F041-02 | INNER keyword |
| F041-03 | LEFT OUTER JOIN |
| F041-04 | RIGHT OUTER JOIN |
| F041-05 | Outer joins can be nested |
| F041-07 | The inner table in a left or right outer join can also be used in an inner join |
| F041-08 | All comparison operators are supported (rather than just =) |
| F051 | Basic date and time |
| F051-01 | DATE data type (including DATE literal) |
| F051-02 | TIME data type (including TIME literal) with fractional seconds precision of 0 |
| F051-03 | TIMESTAMP data type (including TIMESTAMP literal) with fractional seconds precision of 0 and 6 |
| F051-04 | Comparison predicate on DATE, TIME, and TIMESTAMP data types |
| F051-05 | Explicit CAST between datetime types and character types |
| F051-06 | CURRENT_DATE |
| F051-07 | LOCALTIME |
| F051-08 | LOCALTIMESTAMP |
| F081 | UNION and EXCEPT in views |
| F131 | Grouped operations |
| F131-01 | WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views |
| F131-02 | Multiple tables supported in queries with grouped views |
| F131-03 | Set functions supported in queries with grouped views |
| F131-04 | Subqueries with GROUP BY and HAVING clauses and grouped views |
| F131-05 | Single row SELECT with GROUP BY and HAVING clauses and grouped views |
| F181 | Multiple module support |
| F201 | CAST function |
| F221 | Explicit defaults |
| F261 | CASE expression |
| F261-01 | Simple CASE |
| F261-02 | Searched CASE |
| F261-03 | NULLIF |
| F261-04 | COALESCE |
| F311 | Schema definition statement |
| F311-01 | CREATE SCHEMA |
| F311-02 | CREATE TABLE for persistent base tables |
| F311-03 | CREATE VIEW |
| F311-04 | CREATE VIEW: WITH CHECK OPTION |
| F311-05 | GRANT statement |
| F471 | Scalar subquery values |
| F481 | Expanded NULL predicate |
| F501 | Features and conformance views |
| F501-01 | SQL_FEATURES view |
| F501-02 | SQL_SIZING view |
| F501-03 | SQL_LANGUAGES view |
| F812 | Basic flagging |
| S011 | Distinct data types |
| S011-01 | USER_DEFINED_TYPES view |
| T321 | Basic SQL-invoked routines |
| T321-01 | User-defined functions with no overloading |
| T321-02 | User-defined stored procedures with no overloading |
| T321-03 | Function invocation |
| T321-04 | CALL statement |
| T321-05 | RETURN statement |
| T321-06 | ROUTINES view |
| T321-07 | PARAMETERS view |
Mpm Home
Printer friendly