Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Database APIs


You can access Mimer SQL using the following native database application interfaces:

In addition, Mimer SQL supports other interfaces such as PHP and ADO. Please see
http://developer.mimer.com/interfaces for details.

Prerequisites

Application developers using this manual are assumed to have a working acquaintance with the principles of the relational database model in general and of Mimer SQL in particular.

It is also assumed that programmers writing ESQL applications are familiar with the principles of the SQL database management language.

Knowledge of Mimer SQL is of course an advantage, although experience with other standard-compliant SQL implementations will suffice. Experience of Mimer SQL is best gained through interactive use of the BSQL facility, see the Mimer SQL User's Manual, Mimer BSQL.

Competence in at least one of the host programming languages supporting embedded Mimer SQL (i.e. C/C++, COBOL or FORTRAN) is assumed.

Related Mimer SQL Publications

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, make 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.

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.

JDBC

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.

ODBC

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.

SQL Standards

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.

Definitions, Terms and Trademarks

ANSI
American National Standards Institute, Inc.
API
Application Programming Interface
BSQL
The Mimer SQL facility for using SQL interactively or by running a command file
ESQL
The preprocessor for embedded Mimer SQL
IEC
International Electrotechnical Commission
ISO
International Standards Organization
JDBC
The Java database API specified by Sun Microsystems, Inc.
ODBC
Open Database Connectivity
PSM
Persistent Stored Modules, the term used by ISO/ANSI for stored procedures
SQL
Structured Query Language
X/Open
X/Open is a trademark of Open Group

All other trademarks are the property of their respective holders.


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