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.
In Mimer SQL version 10.1 there are two types of database servers; Mimer SQL Engine and Mimer SQL Experience. The major part of the documentation is valid for both server types. However, in cases there are differences between Mimer SQL Engine and Mimer SQL Experience, they are documented in "boxes" like below:
Mimer SQL Engine is a continuation of the long line of database servers from Mimer Information Technology. It preserves backward compatibility and is intended for production systems that are upgraded from earlier versions of Mimer SQL.
Mimer SQL Experience is a new product and has an SQL compiler that has been developed with many additional optimization techniques and rich SQL language support.
Related Mimer SQL Publications
- Mimer SQL Programmer's Manual
- Mimer SQL User's Manual
is user-oriented guide to the SQL statements, which may provide help for less experienced users in formulating statements correctly (particularly the SELECT statement, which can be quite complex). Does also contain a description of the BSQL utility.
- Mimer SQL System Management Handbook
describes system administration functions, including export/import, backup/restore, databank shadowing and the statistics functionality. The SQL statements which are part of the System Management API are described in the Mimer SQL Reference Manual.
- Mimer SQL Platform-specific Documents
- Mimer SQL Release Notes
- Mimer JDBC Guide
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.
Official documentation of the accepted SQL standards may be found in:
ISO/IEC 9075:2011(E) Information technology - Database languages - SQL. This document contains the standard referred to as SQL-2011.
Acronyms, Terms and Trademarks
API Application Programming Interface BSQL The Mimer SQL facility for using SQL interactively or by running a command file CAE Common Applications Environment CLI Call Level Interface ENV Européenne Norme Vorausgabe, European Pre-Standard EOR European Ordering Rules IEC International Electrotechnical Commission ISO International Standards Organization JDBC The Java database API specified by Sun Microsystems, Inc. NFC Normalization Form C NIST National Institute of Standards and Technology ODBC Open Data Base Connectivity PSM Persistent Stored Modules, the term used by ISO/ANSI for stored procedures SDK Software Development Kit SQL Structured Query Language UCA Unicode Collation Algorithm UCS 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