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 Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se