Re: dbaccess sql output
In article <5jnufr$fus@cssun.mathcs.emory.edu>,
twright@inbrand.com (Terron Wright) wrote:
>
>Is there away to force a sql dbaccess script to produce output with each
>record being displayed horizontally? My script is:
>
> select * from atable>
>The output looks like this:
>
> acolumn1 test
> acolumn2 test2
> acolumn3 test3
> acolumn4 test4
>
>I would like for the report to look like this:
>
> acolumn1 acolumn2 acolumn3 acolumn4
>
>I can do this if I do a select and put in each individual column but
>that is time consuming. Does anyone have a solution or suggestion?
Don't to forget the FAQ, which says...
David Cortesi (cortesi@informix.com) has a nice utility at
ftp://ftp.iiug.org/pub/informix/pub/reform_sql.Z
Cheers,
Kerry S
------------------------------------,------------------------------------------
Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.8 March 1997
Quanta Systems, Auckland | http://www.iiug.org/techinfo/faq/
New Zealand. Work: +64 9 377-4473 | ftp://ftp.iiug.org/pub/informix/faq
Home: +64 9 279-3571 | ftp://kcbbs.gen.nz:/pub/informix/