Writing results to a file

Posted in 2008

Topics: Migration, Import/Export & Data Conversion

BigBob — Mon, 14 Jul 2008 10:21:06 -0700 (PDT) — source: Usenet: comp.databases.informix

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

↪ replying to BigBob

Campbell, John (GE Money) — Mon, 14 Jul 2008 13:27:22 -0400 — source: Usenet: comp.databases.informix

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

↪ replying to Campbell, John (GE Money)

BigBob — Mon, 14 Jul 2008 10:44:16 -0700 (PDT) — source: Usenet: comp.databases.informix

On Jul 14, 10:27 am, "Campbell, John (GE Money)" <John.Campbe...@ge.com> wrote: > Try the output to a file option in dbaccess... > > > > -----Original Message----- > From: informix-list-boun...@iiug.org > > [mailto:informix-list-boun...@iiug.org] On Behalf Of BigBob > Sent: Monday, July 14, 2008 1:21 PM > To: informix-l...@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-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list- Hide quoted text - > > - Show quoted text - thank you. I will look into that. We were hoping to run this from a stored procedure as well.