Re: DBACCESS Select output in colums

In article <34C63452.15DF@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes >Gabriel Basco Guimaraens wrote: >> >> How can I use DBACCESS to get my output select statement in columns instead >> of row format? > >You cannot. DBACCESS formats by solumn or row depending on whether the >output fits in 80 columns. The best solution is to use the DBACCESS >unload command and post process the delimited output file using awk or >perl or "C" etc. > >Art S. Kagel Or if you have long description columns try, select ...,description[1,20] desc, ... .... to try and get the width of the total output to less than 80 characters. -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care