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

UNIX-style
VMS-style
Function
 -u[username]
 /USER[=username]
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.
 -p[password]
 /PASSWORD[=password]
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.
 -m
 /MULTI
Connects to the database in multi-user mode.
 -s
 /SINGLE
Connects to the database in single-user mode.
 -qquery
 /QUERY=query
query can be any BSQL command or SQL statement. If a query is supplied, BSQL will terminate immediately after the query has been processed.
 database
 database
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
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