[Monetdb-developers] multiple XQuery statements in one xq file
Dear Sjoerd or other developers,
Could you please change the "MapiClient -lx" protocol such that the end of query does not coincide with end-of-file? We would like to provide little XQuery scripts with multiple XQuery statements, but of course I cannot put the end-of-file mark into that file without ending the file (well, you know what I mean). Any end-of-query marker will do, but ';' would be prefered I guess, to stay in line with Mil and SQL.
For instance (Similar to having multiple SQL insert statements):
pf:add-doc("http://www.utwente.nl/a1.xml", "a1.xml"); pf:add-doc("http://www.utwente.nl/a2.xml", "a2.xml"); pf:add-doc("http://www.utwente.nl/a3.xml", "a3.xml");
I know I can do this in one transaction, but I do not want to.
Best, Djoerd.
On 13-04-2007 12:33:09 +0200, Djoerd Hiemstra wrote:
Dear Sjoerd or other developers,
Could you please change the "MapiClient -lx" protocol such that the end of query does not coincide with end-of-file? We would like to provide little XQuery scripts with multiple XQuery statements, but of course I cannot put the end-of-file mark into that file without ending the file (well, you know what I mean). Any end-of-query marker will do, but ';'
JdbcClient used to use this "statement separator", but in XQuery it is not correct, as ; is used in XQuery itself. Wouter and Jens probably can easily come up with an example of ; being not correct.
would be prefered I guess, to stay in line with Mil and SQL.
For instance (Similar to having multiple SQL insert statements):
pf:add-doc("http://www.utwente.nl/a1.xml", "a1.xml"); pf:add-doc("http://www.utwente.nl/a2.xml", "a2.xml"); pf:add-doc("http://www.utwente.nl/a3.xml", "a3.xml");
I know I can do this in one transaction, but I do not want to.
I believe Peter implemented something like <> as separator, but I'm not sure on that one.
a function would be the counterexample:
declare function x() as node { () }; x()
myXQ, wouter
-----Original Message----- From: monetdb-developers-bounces@lists.sourceforge.net [mailto:monetdb-developers-bounces@lists.sourceforge.net] On Behalf Of Fabian Groffen Sent: vrijdag 13 april 2007 12:44 To: monetdb-developers@lists.sourceforge.net Subject: Re: [Monetdb-developers] multiple XQuery statements in one xq file
On 13-04-2007 12:33:09 +0200, Djoerd Hiemstra wrote:
Dear Sjoerd or other developers,
Could you please change the "MapiClient -lx" protocol such that the end of query does not coincide with end-of-file? We would like to provide little XQuery scripts with multiple XQuery statements, but of course I cannot put the end-of-file mark into that file without ending the file (well, you know what I mean). Any end-of-query marker will do, but ';'
JdbcClient used to use this "statement separator", but in XQuery it is not correct, as ; is used in XQuery itself. Wouter and Jens probably can easily come up with an example of ; being not correct.
would be prefered I guess, to stay in line with Mil and SQL.
For instance (Similar to having multiple SQL insert statements):
pf:add-doc("http://www.utwente.nl/a1.xml", "a1.xml"); pf:add-doc("http://www.utwente.nl/a2.xml", "a2.xml"); pf:add-doc("http://www.utwente.nl/a3.xml", "a3.xml");
I know I can do this in one transaction, but I do not want to.
I believe Peter implemented something like <> as separator, but I'm not sure on that one.
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=D... _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
Fabian Groffen wrote:
On 13-04-2007 12:33:09 +0200, Djoerd Hiemstra wrote:
Dear Sjoerd or other developers,
Could you please change the "MapiClient -lx" protocol such that the end of query does not coincide with end-of-file? We would like to provide little XQuery scripts with multiple XQuery statements, but of course I cannot put the end-of-file mark into that file without ending the file (well, you know what I mean). Any end-of-query marker will do, but ';'
JdbcClient used to use this "statement separator", but in XQuery it is not correct, as ; is used in XQuery itself. Wouter and Jens probably can easily come up with an example of ; being not correct.
would be prefered I guess, to stay in line with Mil and SQL.
For instance (Similar to having multiple SQL insert statements):
pf:add-doc("http://www.utwente.nl/a1.xml", "a1.xml"); pf:add-doc("http://www.utwente.nl/a2.xml", "a2.xml"); pf:add-doc("http://www.utwente.nl/a3.xml", "a3.xml");
I know I can do this in one transaction, but I do not want to.
I believe Peter implemented something like <> as separator, but I'm not sure on that one.
This is correct. You can use <> at the start of a line as separator, but only in XQuery mode.
On Friday 13 April 2007 13:11, Sjoerd Mullender wrote:
Fabian Groffen wrote:
On 13-04-2007 12:33:09 +0200, Djoerd Hiemstra wrote:
Dear Sjoerd or other developers,
Could you please change the "MapiClient -lx" protocol such that the end of query does not coincide with end-of-file? We would like to provide little XQuery scripts with multiple XQuery statements, but of course I cannot put the end-of-file mark into that file without ending the file (well, you know what I mean). Any end-of-query marker will do, but ';'
JdbcClient used to use this "statement separator", but in XQuery it is not correct, as ; is used in XQuery itself. Wouter and Jens probably can easily come up with an example of ; being not correct.
would be prefered I guess, to stay in line with Mil and SQL.
For instance (Similar to having multiple SQL insert statements):
pf:add-doc("http://www.utwente.nl/a1.xml", "a1.xml"); pf:add-doc("http://www.utwente.nl/a2.xml", "a2.xml"); pf:add-doc("http://www.utwente.nl/a3.xml", "a3.xml");
I know I can do this in one transaction, but I do not want to.
I believe Peter implemented something like <> as separator, but I'm not sure on that one.
This is correct. You can use <> at the start of a line as separator, but only in XQuery mode.
I tried to do this but it did not work. My input file was =======x.xq============ 1+1 <> 2+2 ====================== And the result was:
flokstra@ewi581:~/scripts> MapiClient -lx x.xq MAPI = monetdb@localhost:50000 QUERY = 1+1 <> 2+2 ERROR = !parse error: syntax error, unexpected invalid_character on line 2, column 3 (next token is `>') !parse error: XQuery parsing failed !# halted in parser.y (PFparse), line 2898 flokstra@ewi581:~/scripts>
JanF.
Jan Flokstra wrote:
On Friday 13 April 2007 13:11, Sjoerd Mullender wrote:
Fabian Groffen wrote:
On 13-04-2007 12:33:09 +0200, Djoerd Hiemstra wrote:
Dear Sjoerd or other developers,
Could you please change the "MapiClient -lx" protocol such that the end of query does not coincide with end-of-file? We would like to provide little XQuery scripts with multiple XQuery statements, but of course I cannot put the end-of-file mark into that file without ending the file (well, you know what I mean). Any end-of-query marker will do, but ';'
JdbcClient used to use this "statement separator", but in XQuery it is not correct, as ; is used in XQuery itself. Wouter and Jens probably can easily come up with an example of ; being not correct.
would be prefered I guess, to stay in line with Mil and SQL.
For instance (Similar to having multiple SQL insert statements):
pf:add-doc("http://www.utwente.nl/a1.xml", "a1.xml"); pf:add-doc("http://www.utwente.nl/a2.xml", "a2.xml"); pf:add-doc("http://www.utwente.nl/a3.xml", "a3.xml");
I know I can do this in one transaction, but I do not want to.
I believe Peter implemented something like <> as separator, but I'm not sure on that one.
This is correct. You can use <> at the start of a line as separator, but only in XQuery mode.
I tried to do this but it did not work. My input file was =======x.xq============ 1+1 <> 2+2 ====================== And the result was:
flokstra@ewi581:~/scripts> MapiClient -lx x.xq MAPI = monetdb@localhost:50000 QUERY = 1+1 <> 2+2 ERROR = !parse error: syntax error, unexpected invalid_character on line 2, column 3 (next token is `>') !parse error: XQuery parsing failed !# halted in parser.y (PFparse), line 2898 flokstra@ewi581:~/scripts>
JanF.
Are you using the development version? Did you update? Especially clients in this case.
On Friday 13 April 2007 14:16, Sjoerd Mullender wrote:
Jan Flokstra wrote:
On Friday 13 April 2007 13:11, Sjoerd Mullender wrote:
Fabian Groffen wrote:
On 13-04-2007 12:33:09 +0200, Djoerd Hiemstra wrote:
Dear Sjoerd or other developers,
Could you please change the "MapiClient -lx" protocol such that the end of query does not coincide with end-of-file? We would like to provide little XQuery scripts with multiple XQuery statements, but of course I cannot put the end-of-file mark into that file without ending the file (well, you know what I mean). Any end-of-query marker will do, but ';'
JdbcClient used to use this "statement separator", but in XQuery it is not correct, as ; is used in XQuery itself. Wouter and Jens probably can easily come up with an example of ; being not correct.
would be prefered I guess, to stay in line with Mil and SQL.
For instance (Similar to having multiple SQL insert statements):
pf:add-doc("http://www.utwente.nl/a1.xml", "a1.xml"); pf:add-doc("http://www.utwente.nl/a2.xml", "a2.xml"); pf:add-doc("http://www.utwente.nl/a3.xml", "a3.xml");
I know I can do this in one transaction, but I do not want to.
I believe Peter implemented something like <> as separator, but I'm not sure on that one.
This is correct. You can use <> at the start of a line as separator, but only in XQuery mode.
I tried to do this but it did not work. My input file was =======x.xq============ 1+1 <> 2+2 ====================== And the result was:
flokstra@ewi581:~/scripts> MapiClient -lx x.xq MAPI = monetdb@localhost:50000 QUERY = 1+1 <> 2+2 ERROR = !parse error: syntax error, unexpected invalid_character on line 2, column 3 (next token is `>') !parse error: XQuery parsing failed !# halted in parser.y (PFparse), line 2898 flokstra@ewi581:~/scripts>
JanF.
Are you using the development version? Did you update? Especially clients in this case.
My clients version was stone-age-like 1.5 week old. I updated and now it works:-)
Thanks, JanF.
participants (5)
-
Djoerd Hiemstra -
Fabian Groffen -
Jan Flokstra -
Sjoerd Mullender -
Wouter Alink