Executing SQL Statements
To execute SQL statements you can use DbVisualizer or BSQL, both included in the Mimer distribution.
The Mimer BSQL program supports a number of command-line arguments. See Mimer SQL System Management Handbook, Mimer BSQL for a detailed description.
The syntax for Mimer BSQL (expressed in UNIX-style) is as follows:bsql [-u[username]] [-p[password]] [-s|-m] [-qquery] [database]
-mis specified for the optional mode flag, the way the database is accessed will be determined by the setting of the
MIMER_MODEvariable, 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.
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.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40