Re: dbaccess sql output
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