Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Features Outside Core Supported by Mimer SQL


Feature ID
Feature Name
B021
Direct SQL
B031
Basic dynamic SQL
B032
Extended dynamic SQL
B033
Untyped SQL invoked function argument
F032
CASCADE drop behavior
F033
ALTER TABLE statement: DROP COLUMN clause
F034
Extended REVOKE statement
F052
Intervals and datetime arithmetic
F053
OVERLAPS predicate
F111
Isolation levels other than SERIALIZABLE
F121
Basic diagnostics management
F171
Multiple schemas per user
F191
Referential delete actions
F222
INSERT statement: DEFAULT VALUES clause
F231
Privilege tables
F251
Domain support
F271
Compound character literals
F281
LIKE enhancements
F341
Usage tables
F361
Subprogram support
F381
Extended schema manipulation
F382
Alter column data type
F391
Long identifiers
F401-01
NATURAL JOIN
F401-04
Mimer SQL Experience:
CROSS JOIN
F421
National character
F431
Read-only scrollable cursors
F441
Extended set function support
F442
Mixed column references in set functions
F491
Constraint management
F555
Enhanced seconds precision
F561
Full value expressions
F661
Mimer SQL Experience:
Simple tables
F701
Referential update actions
F731
INSERT column privileges
F771
Connection management
F781
Self-referencing operations
P006
Mimer SQL Experience:
Multiple assignment
S023
Mimer SQL Engine:
Basic structured types
S024
Mimer SQL Engine:
Enhanced structured types
S027
Create method by specific method name
S028
Permutable UDT options list
S071
SQL paths in function and type name resolution
T011
Timestamp in Information Schema
T021
BINARY and VARBINARY data types
T022
Advanced support for BINARY and VARBINARY data types
T031
BOOLEAN data type
T041
Basic LOB data type support. Mimer SQL does not support the following sub-features:
T041-03 "POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types" (except SUBSTRING that is supported)
T041-04 "Concatenation of LOB data types"
T041-05 "LOB locator: non-holdable".
T071
BIGINT data type
T121
Mimer SQL Experience:
WITH (excluding RECURSIVE ) in query expression
T122
Mimer SQL Experience:
WITH (excluding RECURSIVE ) in subquery
T176
Sequence generator support
T211
Basic trigger capability
T212
Enhanced trigger capability
T241
START TRANSACTION statement
T441
ABS and MOD functions
T461
Symmetric BETWEEN predicate
T501
Enhanced EXISTS predicate
T551
Optional key words for default syntax
T591
UNIQUE constraints of possibly null columns
P001
Stored modules
P002
Computational completeness
P003
Information Schema views


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