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.