Hi,

String literals in MAL are differently quoted than SQL.

Use " instead of '

regards, Martin

On 08/06/2013 11:01 AM, integrity wrote:
Hi Stefan,
there is still some thing wrong with the query simply using fits.attatch....

mal>fits.attach('/home/data1/20130111_177d550752_60d851283-530.fit');
MAPI  = (monetdb) /tmp/.s.monetdb.50000
QUERY = fits.attach('/home/data1/20130111_177d550752_60d851283-530.fit');
ERROR = !SyntaxException:parseError:fits.attach('/home/data1/20130111_177d550752_60d851283-530.fit');
!SyntaxException:parseError:           ^',' expected
mal>
mal>


------------------ Original ------------------
From:  "Stefan Manegold"<Stefan.Manegold@cwi.nl>;
Date:  Tue, Aug 6, 2013 03:10 PM
To:  "Communication channel for MonetDB users"<users-list@monetdb.org>;
Subject:  Re: Data Vault:SyntaxException

Hi,

there is no "call" in MAL, hence, it's simply:
fits.attach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');

please refer to the MAL documentation at
http://www.monetdb.org/Documentation/Manuals/MonetDB/MALreference
and further.

Stefan

----- Original Message -----
> hi all,
>
>
> What's the correct way to use FIT DATA VAULT in mal?
>
>
> I got the following errors and still havent try out the right syntax ......
>
>
>
>
> [svomhpc@localhost /home/data2]$>/home/data1/opt/MonetDB.fits/bin/mclient
> -lmal -dmydb
> Welcome to mclient, the MonetDB interactive terminal (unreleased)
> Type \q to quit, \? for a list of available commands
> mal>?fits.attach()
> pattern fits.attach(fname:str):void
> address FITSattach;
> comment Open a FITS file and return catalog of the table HDUs
>
>
> mal>call
> fits.attach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');
> MAPI  = (monetdb) /tmp/.s.monetdb.50000
> QUERY = call
> fits.attach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');
> ERROR = !SyntaxException:parseError:call
> fits.attach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');
>         !SyntaxException:parseError:    ^';' expected
> mal>
> mal>
> mal>call
> fitsattach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');
> MAPI  = (monetdb) /tmp/.s.monetdb.50000
> QUERY = call
> fitsattach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');
> ERROR = !SyntaxException:parseError:call
> fitsattach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');
>         !SyntaxException:parseError:    ^';' expected
> mal>
> mal>call
> FITSattach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');
> MAPI  = (monetdb) /tmp/.s.monetdb.50000
> QUERY = call
> FITSattach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');
> ERROR = !SyntaxException:parseError:call
> FITSattach('/home/data3/gwacdata/20130111_177d550752_60d851283-530.fit');
>         !SyntaxException:parseError:    ^';' expected
>
>
>
>
> Thanks!
> Meng
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> http://mail.monetdb.org/mailman/listinfo/users-list
>

--
| Stefan.Manegold@CWI.nl | DB Architectures   (DA) |
| www.CWI.nl/~manegold/  | Science Park 123 (L321) |
| +31 (0)20 592-4212     | 1098 XG Amsterdam  (NL) |

_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list
.


_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list