Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

About this Manual

The manual is intended for all users of Mimer SQL in both interactive and embedded contexts. It contains a complete description of the syntax and usage of all statements in Mimer SQL.

Related Mimer SQL Publications

Suggestions for Further Reading

We can recommend to users of Mimer SQL the many works of C. J. Date. His insight into the potential and limitations of SQL, coupled with his pedagogical talents, makes his books invaluable sources of study material in the field of SQL theory and usage. In particular, we can mention the following publication:

A Guide to the SQL Standard (Fourth Edition, 1997). ISBN 0-201-96426-0. This work contains much constructive criticism and discussion of the SQL standard, including SQL-99.

Other useful publications are:

SQL: 1999 - Understanding Relational Language Concepts, by Jim Melton, Alan R. Simon, and Jim Gray. ISBN 1-55860-456-1. Explains SQL-99.

Advanced SQL: 1999 - Understanding Object-Relational and Other Advanced Features, by Jim Melton. ISBN 1-55860-677-7. In-depth guide to SQL-99's practical application.

Unicode information can be found here http://www.unicode.org.

For JDBC Users

JDBC information can be found here http://www.oracle.com/technetwork/java/.

For information on specific JDBC methods, please see the documentation for the java.sql package. This documentation is normally included in the Java development environment.

JDBC API Tutorial and Reference, 2nd edition. ISBN 0-201-43328-1. A useful book published by JavaSoft.

For ODBC Users

Microsoft ODBC 3.0 Programmer's Reference and SDK Guide for Microsoft Windows and Windows NT. ISBN 1-57231-516-4.

This manual contains information about the Microsoft Open Database Connectivity (ODBC) interface, including a complete API reference.

The documentation set in the Mimer SQL Windows distribution includes an ODBC API help.

SQL Standards

Official documentation of the accepted SQL standards may be found in:

ISO/IEC 9075:2016(E) Information technology - Database languages - SQL. This document contains the standard referred to as SQL-2016.

Acronyms, Terms and Trademarks

Application Programming Interface
The Mimer SQL facility for using SQL interactively or by running a command file
Common Applications Environment
Call Level Interface
Européenne Norme Vorausgabe, European Pre-Standard
European Ordering Rules
International Electrotechnical Commission
International Standards Organization
The Java database API specified by Sun Microsystems, Inc.
Normalization Form C
National Institute of Standards and Technology
Open Data Base Connectivity
Persistent Stored Modules, the term used by ISO/ANSI for stored procedures
Software Development Kit
Structured Query Language
Unicode Collation Algorithm
Universal Multiple-Octet Coded Character Set

All other trademarks are the property of their respective holders.

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