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