| Subject | Re: [firebird-support] Export data to CSV file from stored procedure? |
|---|---|
| Author | Tim Ward |
| Post date | 2014-08-20T16:26:34Z |
You want to be looking around your
external CSV file being an "external table" - that's the only way
to write to files from stored procedures AFAIK, so, no matter how
convoluted the code ends up, that's probably the approach you'll
have to take.
(Unless there's new stuff in 2.5 I don't know about, I've only done this with 2.1.)
(Unless there's new stuff in 2.5 I don't know about, I've only done this with 2.1.)
On 20/08/2014 17:19, conversar@... [firebird-support] wrote:
Hi there,
As subject, is it possible to export a query result set to an external csv file from a Firebird stored procedure? I know this can be done with IBExpert but we are looking for a pure firebird sql solution. We are using Firebrd 2.5.
Any pointers on how to do this will be much appreciated.
Regards,
-Ed
-- Tim Ward