www.mimer.com/developer

About Mimer SQL for OpenVMS

---

You can download a full version of Mimer SQL for OpenVMS for free from
http://developer.mimer.com/downloads. This distribution is for development and evaluation. It contains a complete copy of Mimer SQL version 8.2.4 and a built-in software key, with no time-limit. It supports up to 10 concurrent database connections.

Mimer SQL Run-time License

To use Mimer SQL for OpenVMS in production, you need a run-time license key.

Please contact your local Mimer representative, see
www.mimer.com/contact/ or e-mail info@mimer.com.

The Mimer SQL Database Server

The Mimer SQL database server is a single, multi-threaded process. By using DecThreads, good SMP scalability is achieved.

Clients using TCP/IP or Decnet can access the server. For clients running on the same platform, a special shared-memory based communication method is used.

Embedded SQL

An embedded SQL preprocessor is included. It enables SQL commands to be embedded in programs written in C, C++, FORTRAN and COBOL. The embedded syntax complies with the ISO standard for embedded SQL.

JDBC Driver

A JDBC driver is included in the distribution. The driver is a type 4 driver, which means that it is written entirely in Java. This provides the driver with full portability so that it can be copied or downloaded to any Java-enabled platform. The driver uses TCP/IP to access a Mimer SQL 8.2.4 server on any platform.

The JDBC driver supports JDBC version 1.2 which makes it suitable for use with the JDK 1.1.8 platform included in OpenVMS 7.2. Mimer will soon release a JDBC version 2 driver which is suitable for the Java 2 platform.

ODBC Driver

The Mimer ODBC driver is a client library that enables applications to access Mimer database servers running on any platform. The driver complies with the ODBC 3.52 specification.

By using the ODBC driver on OpenVMS, you can develop ODBC applications and execute them on the OpenVMS platform.

Unlike other platforms, OpenVMS does not include a Driver Manager that enables OpenVMS applications to dynamically load drivers for different database products. Until such a Driver Manager becomes available on OpenVMS, you can link your applications directly to the Mimer ODBC driver.

Note that in order to run an ODBC application on a Windows platform, the Windows ODBC driver has to be installed on the client side. This driver can then access Mimer database servers on any platform (including OpenVMS). There is no need to install any special software on the server side in order to use ODBC.

Utilities

Mimer SQL includes the following utilities:

Utility	Description
BSQL	BSQL executes SQL statements which are entered interactively or read from a command file. It is described in the Mimer SQL User's Manual.
DBC	DBC check if a databank file is internally consistent. It is described in the Mimer SQL System Management Handbook.
DBOPEN	DBOPEN opens and restarts all databanks in a database. It is described in the Mimer SQL System Management Handbook.
ESQL	ESQL is a pre-processor for embedded SQL.
MIMCONTROL	MIMCONTROL provides facilities for managing the operation of a database server, for example, starting, controlled shutdown, etc.
MIMINFO	MIMINFO displays status information for a database server.
MIMLICENSE	Utility for managing Mimer SQL licenses.
PSMDEBUG	Java-based utility for debugging PSM procedures.
SDBGEN	SDBGEN generates the Mimer SQL system databanks SYSDB, TRANSDB, LOGDB and SQLDB.
UTIL	Utility functions for a database, see the Mimer SQL System Management Handbook.

The Mimer SQL distribution also contains examples of database programs and SQL statements. See Distributed Files for more information

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se