Re: dbaccess sql output
Kerry Sainsbury wrote:
>
> 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/
or try:
create temp table ttt (fff char(999));
insert into tttselect field1 || field2 ....|| 'end' from sometable;
unload to ttt.unl select fff from ttt;
--
Klaus Gotthardt
email: K.Gotthardt@em.uni-frankfurt.de
home : http://www.rz.uni-frankfurt.de/~gotthard