How to use procedures in ij?

2011-05-30 Thread Malte.Kempff
Hi to all, i was looking for a possibility to write out results of querreis into a a CSV-file and found a procedure for that (SYSCS_UTIL.SYSCS_EXPORT_QUERY) But how can I use it within IJ? Is there a possibility? Thanks a lot in advance for any hint Malte

AW: How to use procedures in ij?

2011-05-30 Thread Malte.Kempff
Ahh ok I found it, call is the magic word, I was missing in the output of ij's help command. So never mind :-) Von: malte.kem...@de.equens.com [mailto:malte.kem...@de.equens.com] Gesendet: Montag, 30. Mai 2011 11:44 An: derby-user@db.apache.org Betreff:

Re: How to use procedures in ij?

2011-05-30 Thread Knut Anders Hatlen
malte.kem...@de.equens.com writes: Hi to all, i was looking for a possibility to write out results of querreis into a a CSV-file and found a procedure for that (SYSCS_UTIL.SYSCS_EXPORT_QUERY) But how can I use it within IJ? Is there a possibility? Hi Malte, Here's an IJ session that

Re: CASE [expression] WHEN [expression] THEN [expression] END syntax

2011-05-30 Thread Dag H. Wanvik
Lukas Eder lukas.e...@gmail.com writes: Hi Dag, If you'd like to have a go, have a look at the parser in derby src root/java/engine/org/apache/derby/impl/sql/compile/sqlgrammar.jj I've had a look. Looks like a lot of stuff I'd have to find out first before even getting the project(s) to

Re: Disappearing service.properties file

2011-05-30 Thread Bryan Pendleton
problems above. I suspect derby has been terminated or interrupted while updating the service.properties file and left the file system in an inconsistent state. Although I imagine the window for this to happen would be fairly narrow. As far as I can tell the call to

Re: CASE [expression] WHEN [expression] THEN [expression] END syntax

2011-05-30 Thread Lukas Eder
Hi Dag, That's fine, Lukas, I know it can be a big inhale.. In the interest of further streamlining our build environment, was there anything is particualar that you had issues with, or was it just that the instructions look intimidating? In any case, thats for your interest! These were my

Re: Disappearing service.properties file

2011-05-30 Thread Dag H. Wanvik
Hi Brett, some possibilities below. Brett Mason b.ma...@adinstruments.com writes: We've recently had some of customer reports come in where Derby is failing with problems related to service.properties. There are three different cases but all appear to be similar: Case 1: ERROR XBM0S:

Re: CASE [expression] WHEN [expression] THEN [expression] END syntax

2011-05-30 Thread Dag H. Wanvik
Lukas Eder lukas.e...@gmail.com writes: 2. It took me a while to understand that some of the missing artefacts are actually generated (such as the output from sqlgrammar.jj). I imagine that can be done with the main build target in the ant build.xml This is correct. sqlgrammar.jj is written

RE: Disappearing service.properties file

2011-05-30 Thread Brett Mason
-Original Message- From: Dag H. Wanvik [mailto:dag.wan...@oracle.com] Sent: Tuesday, 31 May 2011 04:43 To: Derby Discussion Subject: Re: Disappearing service.properties file Hi Brett, some possibilities below. Brett Mason b.ma...@adinstruments.com writes: We've