Re: dbaccess sql output

I guess you could try this: select acolumn1||acolumn2||acolumn3||acolumn4 from atable -- Valery Fouques valou@hotmail.com SYSADM GOSPORT-FRANCE /\\oO/\\ _ __/| \\`O.o' "355/113 -- Not the famous irrational =(_ _)= number PI, but an incredible simulation!" U Carlos Antonio Ruiz Gomez <dmys2@colomsat.net.co> wrote in article <5k2bst$la@cssun.mathcs.emory.edu>... > 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? > > I found a very useful utility to make that in this addres: > http://www.iiug.org/techinfo/faq/ifaq10.htm#10 > > The following lines are from that site. > > reform > > David Cortesi (cortesi@informix.com) has a nice utility > ftp://ftp.iiug.org/pub/informix/pub/reform_sql.Z capable of reformating > ISQL vertical-format reports > from this: > > # order_num 1007 > # order_date 03/25/1989 > # customer_num 117 > # backlog n > # po_num 278693 > # ship_date 04/23/1989 > # ship_weight 125.90 > > into a horizontal format like this: > > # order_num order_date customer_num backlog po_num ship_date > ship_weight > # 1007 03/25/1989 117 n 278693 04/28/1989 125.90 > # 1012 06/05/1989 117 n 278701 06/09/1989 70.80 >