db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <knut.hat...@oracle.com>
Subject Re: How to use procedures in ij?
Date Mon, 30 May 2011 10:08:02 GMT
<Malte.Kempff@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

Mime
View raw message