Re: dbaccess sql output
Posted in 1997
Harald Ums — — source: Informix-list mailing list archive (1991-1998)
why not simply
unload to '/dev/stdout'
select * from atable;
Harald Ums
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?