Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


SQL-2003 Core Features


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


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX