www.mimer.com/developer

Editing the SQLHOSTS File

---

The SQLHOSTS file is used to list all the databases that are accessible to a Mimer SQL application from the node on which it is installed.

On a VMS node, the SQLHOSTS file is located by translating the logical name MIMER_SQLHOSTS.

The MIMSETUP8 command will define it to be:

 SYS$SPECIFIC:[SYSMGR]SQLHOSTS.DAT 
 

A default SQLHOSTS file is installed the first time you run MIMSETUP8.

The SQLHOSTS file contains three sections:

• LOCAL

  The LOCAL section contains the names of the local databases on the current node, see Adding a Local Database.

• REMOTE

  The REMOTE section contains the names of remote databases accessible from the node, see Accessing a Remote Database.

• DEFAULT

  One of the local or remote databases can be set to be the default database for the node by specifying its name in the DEFAULT section, see Specifying the Default Database.

Note: In the SQLHOSTS file, a line of text beginning with the character sequence -- is interpreted as a comment.
The maximum length for the name of a database on an OpenVMS node is 30 characters.

Adding a Local Database

To add a local database:

1. Open the SQLHOSTS file in a text editor and locate the LOCAL section.
2. Under Database, enter the name of the database.
3. Under Path, enter the name of the directory which is to be the data base's home directory.

Example of a LOCAL Entry

 LOCAL:
 --
 -- Database           Path
 -- ------------------ -------------------------------------------------
    M8SERVER           DISK:[DIRECTORY]
 -- ======================================================================

Specifying the Default Database

The DEFAULT section in the SQLHOSTS file contains a single line that specifies the default database. This is the database which will be used if a database is not explicitly specified when logging on.

The default database must be listed in either the LOCAL or the REMOTE section.

Example of a Default Entry

 DEFAULT:
 --
 -- Database
 --====================================================================
    M8SERVER
 --====================================================================

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