You can access Mimer SQL using the following user interfaces:
- Mimer BSQL
- Embedded SQL (ESQL)
ESQL is used through a host programming language - the programmer writes SQL statements as part of the source code for an application program, which is pre-processed and compiled with the appropriate language-specific facilities. The SQL statements are executed in the context of the application program.
There are no prerequisites for users of this manual. However, it is to the user's advantage to be familiar with the principles of the relational database model when working with BSQL.
Related Mimer SQL Publications
- Mimer SQL Reference Manual
- Mimer SQL Programmer's Manual
- Mimer SQL System Management Handbook
Describes system administration functions, including export/import, backup/restore, databank shadowing and the statistics functionality. The information in this manual is used primarily by the system administrator, and is not required by application program developers. 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
Suggestions for Further Reading
We can recommend 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: 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 SQL99.
JDBC information can be found on the internet at: http://java.sun.com/products/jdbc
For information on specific JDBC methods, please see the online 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.
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.
Official documentation of the accepted SQL standards may be found in:
ISO/IEC 9075:1999(E) Information technology - Database languages - SQL. This document contains the standard referred to as SQL99.
ISO/IEC 9075:1992(E) Information technology - Database languages - SQL. This document contains the standard referred to as SQL92.
ISO/IEC 9075-4:1996(E) Database Language SQL - Part 4: Persistent Stored Modules (SQL/PSM). This document contains the standard which specifies the syntax and semantics of a database language for managing and using persistent routines.
CAE Specification, Data Management: Structured Query Language (SQL), Version 2. X/Open document number: C449. ISBN: 1-85912-151-9. This document contains the X/Open-95 SQL specification.
Acronyms, Terms and Trademarks
IEC International Electrotechnical Commission ISO International Standards Organization SQL Structured Query Language PSM Persistent Stored Modules (i.e. Stored Procedures) X/Open X/Open is a trademark of the X/Open Company
All other trademarks are the property of their respective holders.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40