Re: ISQL Question

Julien Mills wrote: > > Hi folks, > > This may have been covered before but, my question is this: > When I type a query in ISQL and run it, if the width of the > columns returned are too big, the result is displayed > horizontally (sp?). > > I would like the output to be all on one horizontal line, with > the column headers on top. > Especially when I'm sending the output to a file. > > TIA, > Julien Mills > jfmills@ix.netcom.com I vaguely recall seeing a reformatter, perhaps in the IIUG site. It converted the list format to table. You can go a long way with awk yourself. If your table is wider than the screen, what do you do? Informix does not provide a viewer that scrolls sideways. Even IBM managed that years ago... -- Peter Lancashire Mail: Peter.Lancashire.PL1 at bayer.co.uk Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281