It's true, documentation is not part of the Windows installer for MonetDB. You can find all documentation on the MonetDB web site (http://monetdb.cwi.nl/).

SQL statements all end with a semicolon, hence all the errors you're getting.

The token number is the internal code for the token in error. I admit, not very useful for anyone other than the developers.

The documentation is available in the tar.gz file; however, it needs to be built first, and this uses tools not normally available on Windows (not on my Windows box, anyway). It is easier to look at the web site.

I hope this helps.

Tolkin, Steve wrote:

Dear Monet users and developers,

I installed Monet on Windows XP using MonetDB-Installer-4.4.0.zip

But there is no user documentation! I took the default directory "c:\program files\CWI\MonetDB" and looked in and below it -- but did not see any documentation.

I want to know the basics, e.g. how to create a table in SQL, populate it, and query it. OI am guessing that a statement ends with a semicolon, but do not know even this. I am guessing that it accepts standard SQL, but that s not clear either. I am able to run the Server, and the Client, and the Mknife tool. I tried a few ways in the Mknife tool, but without success.

For example in the SQL client tool I entered sql>create table t (i integer);

And got back the message: # 6 # querytype

I assume this is some kind of error.

Here is some more of my attempts to do something. Why are the values for token number much higher than the number of tokens in my statement?

sql>create tabel t (c char(1)) more>/ more>; MAPI = monetdb@localhost:45123 QUERY = create tabel t (c char(1)) ERROR = !ERROR parse error at token (258) in statement: create tabel sql>create table t (c char(1)); MAPI = monetdb@localhost:45123 QUERY = create table t (c char(1)); ERROR = !current transaction is aborted (please ROLLBACK) sql>rollback more>create table t (c char(1)); MAPI = monetdb@localhost:45123 QUERY = rollback ERROR = !ERROR parse error at token (372) in statement: rollback !create sql>rollback; # 7 # querytype sql>rollback more>/ more>; MAPI = monetdb@localhost:45123 QUERY = rollback ERROR = !ERROR parse error at token (47) in statement: rollback !/ sql>rollback more>; # 7 # querytype sql>ROLLBACK; # 7 # querytype sql>

I then tried looking for the documentation in MonetDB-4.4.0.tar.gz But this explains how to compile the system, not how to use it.

I think there may be user documentation in the *.rpm files intended for Linux, but I do think I can use those on Windows.

Hopefully helpfully yours, Steve -- Steve Tolkin Steve . Tolkin at FMR dot COM 617-563-0516 Fidelity Investments 82 Devonshire St. V4D Boston MA 02109 There is nothing so practical as a good theory. Comments are by me, not Fidelity Investments, its subsidiaries or affiliates.