Re: how to get SQL output > 80 columns wide?
Oooh! Oooh! Me too, Mr Kotter :-). I just wrote a java program (jselect) to accept any Informix select SQL and return results with/without titles, and in either tabular, columnar or pipe-delimited format from an Informix database. It uses the Informix JDBC driver, and the source code is available on my website at http://www.geocities.com/SiliconValley/Horizon/9144/cdldb005.html. If any of you find it useful, I will be happy to submit a copy to IIUG. HTH Sujit Chuck Renaud <crenaud@informix.com> on 05/26/99 09:38:41 AM Please respond to crenaud@informix.com To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Re: how to get SQL output > 80 columns wide? Presumably, you're talking about DB Access. You can use another SQL query tool or find utilities on the IIUG site (www.iiug.org). To answer your other post, you can also find the FAQ there as well. > I hate it when a select field1, field2, field3 output looks in a nice > columnar format, you now need field4, and it goes to one-field-per-line > mode.... > > How to prevent this? Scheesh, I can use a right-left scrolling pager if I > have to... but sometimes the columns I request dont even add upto 80 > chars!!! > > Ive played with setting stty columns to 132 and hacked termcap entries.... > > Even if the xterm i'm running is already wide and should accomodate... It > wont display past 80 columns!!! > > HELP > alan > -- > +=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ > Alan W. Jurgensen - Full Compass Systems > phone: (608) 831-7330 - email: alan@fullcompass.com > +=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ >
Sujit.Pal@BankAmerica.com wrote: > > Oooh! Oooh! Me too, Mr Kotter :-). > > I just wrote a java program (jselect) to accept any Informix select SQL and > return results with/without titles, and in either tabular, columnar or > pipe-delimited format from an Informix database. It uses the Informix JDBC > driver, and the source code is available on my website at > http://www.geocities.com/SiliconValley/Horizon/9144/cdldb005.html. If any > of you find it useful, I will be happy to submit a copy to IIUG. Tres cool, Sujit. Pack it up into a shell archive with a README file and email it to software@iiug.org so all can share. Art S. Kagel