Re: SE 7.23, DB-access, how to set linelengtn of output

On Thu, 21 Oct 2004 14:50:17 -0400, Peter Michel wrote: This question's so common it's in the Informix FAQ on the IIUG web site. You can either: 1. Use UNLOAD TO to output a delimited file and post process it using C/Perl/Awk/whatever. Or 2. Get one of several scripts and 4GL programs in the IIUG Software Repository to reformat dbaccess output to a more 'normal' format. 3. Get Jonathan Leffler's sqlcmd package from the IIUG Software Repository. Sqlcmd is a commandline SQL processor which has configurable output formatting, and it does not break lines to fit 80 columns as dbaccess does. Art S. Kagel > Hi, > i will create simple lists via c-script and dbaccess, but the output produce > only 80-character lines. If the output is larger is will splitt to one line > for every column. On the output command i can't find the option "without > headers" only, but this will not change the length. The output goes into a > file, not on the screen. Is there a trick the set the linelength? Thanks a > lot! > Cheers Peter