Writing results to a file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BigBob - 14 Jul 2008 18:21 GMT

Does anyone know how I can write the results of an Informix query to a
file with column headings, etc? The unload simply provides the data.
What we need it the ability to show in tabular form, the results
returned as with the SQL Editor.

Thanks!

Bob

Reply to this Message

Campbell, John (GE Money) - 14 Jul 2008 18:27 GMT

Try the output to a file option in dbaccess...

-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of BigBob
Sent: Monday, July 14, 2008 1:21 PM
To: informix-list@iiug.org
Subject: Writing results to a file

Does anyone know how I can write the results of an Informix query to a
file with column headings, etc? The unload simply provides the data.
What we need it the ability to show in tabular form, the results
returned as with the SQL Editor.

Thanks!

Bob
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

Reply to this Message

BigBob - 14 Jul 2008 18:44 GMT

On Jul 14, 10:27 am, "Campbell, John (GE Money)"
<John.Campbe...@ge.com> wrote:

> Try the output to a file option in dbaccess...
>
[quoted text clipped - 19 lines]
>
> - Show quoted text -

thank you. I will look into that. We were hoping to run this from a
stored procedure as well.

Reply to this Message