Installation issues MonetDB/SQL

1. How do I start a SQL console?
2. How do I run a SQL batch program?
3. How do I run a Perl (Python, C, Java, ...) application?
4. Windows installer complaints about DLLs

For MonetDB, SQL functionality is a separate module, which is also in the SourceForge repository. It should be checked out in much the same way as MonetDB itself (change 'MonetDB' into 'sql'). In the root directory of the sql distribution you find the HowtoStart-SQL document, which contains step-by-step instructions. Once you have installed and set up the SQL module, you have to load it in Mserver, for instance using the sql_server.mil script from the lib(64)/MonetDB directory. A SQL console can afterwards be started using mclient -lsql. See mclient --help for more details.

Make sure that you have MonetDB's SQL front-end installed and the sql_server module loaded in your running Mserver. See above for directions on how to do that. Collect the SQL statements in a file, then simply type:
mclient -lsql < batchfile

The MonetDB source tree contains a section Mapi/clients, where you also find sample applications to interact with the server. For most APIs we have included a simple textual monitor to show the basic interaction, called mclient. Try this one first before developing your own applications.

The older Window installers do not always remove MonetDB DLLs. Remove them manually from system32 before installing the new version. It concerns:

1. libstream.dll
2. libmutils.dll
3. libMonetODBCs.dll
4. libMonetODBC.dll
5. libMapi.dll