Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

Running Mimer BSQL

The Mimer BSQL program supports a number of command-line arguments.

The syntax for Mimer BSQL (expressed in UNIX-style) is as follows:

 bsql [-u[username]] [-p[password]] [-s|-m] [-qquery] [database]

BSQL Command-line Arguments

Ident name to be used in connect. If only -u is given an attempt to connect as OS_USER is done. If the -u switch is not given the user is prompted for a username.
Password for ident. If the switch is omitted the user is prompted for a password. When connecting as OS_USER, enter the -p switch only, without specifying password.
Connects to the database in multi-user mode.
Connects to the database in single-user mode.
query can be any BSQL command or SQL statement. If a query is supplied, BSQL will terminate immediately after the query has been processed.
Specifies the name of the database to access. If a database name is not specified, the default database will be accessed, see The Default Database.

If neither -s nor -m is specified for the optional mode flag, the way the database is accessed will be determined by the setting of the MIMER_MODE variable, see Specifying Single-user Mode Access, or, if this is not set, it will be accessed in multi-user mode.

Arguments containing more than one word should be enclosed in ". Note that VMS translates arguments to lower case when UNIX-style syntax is used.


UNIX: The UNIX-style command-line flags must be used on a UNIX machine.

VMS: Either the UNIX-style or the VMS-style command-line flags may be used on an OpenVMS machine - see the Mimer SQL VMS Guide for more details.

Win: The UNIX-style command-line flags can be used from a command prompt window.

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