Re: Can DBAccess display more that 80 cols

Porcello, John wrote: > > Hi all, > > I have a select statement I am running from DBAccess at the UNIX command > line, the select statement is more that 80 Columns, is there a way to > instruct DBAccess to print this in the single line format verses record by > record? > > On that note, is there a way to make the following columns smaller, i.e. > Count(*), sum(pe_size), ti_nextsiz > I attempted to use the trunc(sum(pe_size),-4) hoping for #### column width, > this did not work! There is no way to get dbaccess to stop folding output that is wider than 80 characters. There is a set of scripts in the IIUG Software Repository (no not mine) that can parse and reformat the output. An alternative is to us UNLOAD TO instead of redirecting or using OUTPUT TO and write a fairly simple awk or perl script to reformat the delimited output file. Art S. Kagel