Re: Output from dbaccess
Try using -
select column1 as c1, column2 as c2
from table
if still it does not work, try following.
run the sql from dbaccess -
unload to myfile.out
select column1, column2, column3...
from table
go to the prompt and run -
$ cat myfile.out | awk -F '|' '{ print $1,$2,$3 }'
This should work.
>From: "Bryan Osborne" <bryan.osborne@wilcom.com>
>Reply-To: "Bryan Osborne" <bryan.osborne@wilcom.com>
>To: informix-list@iiug.org
>Subject: Output from dbaccess
>Date: Tue, 15 Aug 2000 21:58:47 GMT
>
>What do I modify/set to get dbaccess to output in a "long column list"
>format instead of the "individually labeled record" format, i.e.,
>
>col1_name col2_name
>record1val1 record1val2
>record2val1 record2val2
>
>instead of:
>
>col1_name record1val1
>col2_name record1val2
>
>col1_name record2val1
>col2_name record2val2
>
>I have one instance which outputs one way and another which outputs the
>other.
>
>Thanks!
>
>
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com