D WDB mSQL Interface

The msql_dbi.pl file makes it possible to use WDB to interface to mSQL.

mSQL ( mini SQL ) is a free database system written by David J. Hughes ( Bambi@Bond.edu.au). It is a lightweight database engine designed to provide fast access to stored data with low memory requirements. As its name implies mSQL offers a subset of SQL as its query interface.

mSQL has been developed under Sun OS 4.1.1 but has been tested under Solaris 2.3, Ultrix 4.3, Linux, FreeBSD 2, and OSF/1 (cc not gcc). That said, it should "autoconf" and build on most BSD derived systems, SVR4 based systems or POSIX O/S's (that should cover most of them). It has been reported that it works out-of-the-box on HP-UX, NeXT, SCO, Sequent, Cray, Tandem and a few others.

mSQL is available from

    ftp://Bond.edu.au/pub/Bond_Uni/Minerva/msql/

Requirements

You need Perl version 5.000 or later with the MsqlPerl extension to use the wdb Informix interface. The Perl5 source is available from :

ftp://ftp.cis.ufl.edu/pub/perl/src/5.0/perl5.000.tar.gz or
ftp://ftp.funet.fi/pub/languages/perl/ports/perl5/perl5.000.tar.gz

The MsqlPerl extension is available from :

    ftp://Bond.edu.au/pub/Minerva/msql/contrib/MsqlPerl-a1.tgz

Configuration

Follow the normal WDB configuration instructions, with the following exceptions :

• Set $DBI_FILE in the wdb.conf file to msql_dbi.pl.
• $DATEFORMAT in the wdb.conf file is ignored.
• Set the first line in the wdb script to perl5 instead of sybperl.

Creating FDF's

Included is also an mSQL version of mkfdf, called msqlfdf, which will produce a working template FDF file given a database and table name.