|
|
|
|
|
|
Database APIs
You can access Mimer SQL using the following user interfaces:
- Mimer BSQL
Mimer BSQL is a command-line oriented tool for executing SQL statements both in batch jobs and interactively. You can use all SQL statements in 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.
- ODBC
ODBC is a database independent interface specified by Microsoft. Through ODBC, Mimer SQL can support many of the tools available on the platforms supporting ODBC (e.g. Windows, UNIX).
- JDBC
JDBCTM is a database independent interface for writing database applications in Java.
Prerequisites
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
Contains a complete description of the syntax and usage of all statements in Mimer SQL and is a necessary complement to this manual.
- Mimer SQL Programmer's Manual
Contains a description of how Mimer SQL can be used within the context of application programs, written in conventional programming languages.
- 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
Containing platform-specific information. A set of one or more documents is provided, where required, for each platform on which Mimer SQL is supplied.
- Mimer SQL Release Notes
Contain general and platform-specific information relating to the Mimer SQL release for which they are supplied.
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 Users
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 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.
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.
Acronyms, Terms and Trademarks
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 dbtechnology@upright.se |
|
|
|
|
|
|