SQL applications can be written in a more vendor independent manner by avoiding non-standard SQL constructions.
The Mimer SQL products complies with the following standards and database API specifications:
- ODBC (Open Database Connectivity)
- JDBC (Java Database Connectivity)
Source: ISO/IEC 9075:2016(E) Information technology – Database languages -SQL. This document is divided into the following parts:
- Part 1: Framework (SQL/Framework)
- Part 2: Foundation (SQL/Foundation)
- Part 3: Call-Level Interface (SQL/CLI)
- Part 4: Persistent Stored Modules (SQL/PSM)
- Part 9: Management of External Data (SQL/MED)
- Part 10: Object Language Bindings (SQL/OLB)
- Part 11: Information and Definition Schemas (SQL/Schemata)
- Part 13: SQL Routines and Types Using the Java TM Programming Language (SQL/JRT)
- Part 14: XML-Related Specifications (SQL/XML)
Part 15: Multi-dimensional arrays (SQL/MDA)
The SQL-2016 standard has replaced the former standards (SQL-92, SQL-99, SQL-2003, SQL-2008 and SQL-2011), as the current SQL standard. For further details on SQL specifications, please see the SQL Standard Features page, where summary tables for Core SQL and Optional SQL can be found.
The Mimer ODBC driver supports ODBC 3.51. For more information, see the database API article covering ODBC, and also the Microsoft’s ODBC overview page.
The Mimer JDBC drivers provide access to Mimer SQL databases from Java applications and applets. The drivers are type 4 drivers, which means that they are written in 100% Java. This allows the drivers to be downloaded in applets.
The Mimer JDBC Driver currently supports version JDBC 3.0. For more information, see the database API article covering JDBC.
Mimer’s policy is to develop Mimer SQL as far as possible in accordance with the established standards. This makes it easier to move applications between different database systems without needing to rewrite a substantial amount of code.
In order to verify SQL statements, an online tool known as the SQL Validator is developed by Mimer Information Technology.
See the Reference Manual in the Mimer SQL Documentation Set..
For further information on JDBC, please see Oracle Java Library.
For detailed information on ODBC, please refer to documentation found on Microsoft's ODBC page.