How to use procedures in ij?

[Ma...@de.equens.com]

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?

[Ma...@de.equens.com]

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.Kempff@de.equens.com [mailto:Malte.Kempff@de.equens.com] 
Gesendet: Montag, 30. Mai 2011 11:44
An: derby-user@db.apache.org
Betreff: How to use procedures in ij?

 

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

Re: How to use procedures in ij?

[Knut Anders Hatlen <kn...@oracle.com>]

<Ma...@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 shows how to write the results from the query
"select * from sys.systables" to the file /tmp/query.txt.

ij version 10.8
ij> connect 'jdbc:derby:db;create=true';
ij> call syscs_util.syscs_export_query('select * from sys.systables', '/tmp/query.txt', null, null, null);
0 rows inserted/updated/deleted
ij> 

Hope this helps,

-- 
Knut Anders