Introduction

SQL applications can be written in a more vendor independent manner by avoiding non-standard SQL constructions.

Mimer complies with the following standards and database API specifications:

  • SQL-2016
  • ODBC (Open Database Connectivity)
  • JDBC (Java Database Connectivity)

Description

SQL-2016

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.

ODBC

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.

JDBC

The Mimer JDBC drivers provide access to Mimer 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.

Mimer currently supports version JDBC 3.0. For more information, see the database API article covering JDBC, and also the Common JDBC overview.

Benefits

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.

Links

See the SQL Reference Manual in the Mimer SQL Documentation Set, found at out Documentation page.

For further information on JDBC, please see Oracle Java Library.

For detailed information on ODBC, please refer to documentation found on http://www.microsoft.com.

Graphic Element - Cube