Re: A solution to SQL reformatting problem (fwd)

In article <9213@emory.mathcs.emory.edu> A.Heskett@bnr.co.uk (Tony Heskett) writes: >X-Informix-List-ID: <list.1328> > > >Steve Price writes (quoting cauhape@twg.com (Jeff Cauhape x7147)) > >> > I've found a solution for UNIX systems. > >Sort of ... > >/usr/gdc/fcddev 10> stty columns 1000 >unknown mode: columns > >uname -a gives: > >OSx64 moses 5.0d-900928 0909i Pyramid-9815 > >HP-UX gdc A.08.00 B 9000/855 116104132 > I have the same problem on ATT 3B20. SO the solution is not a solution. Too bad. I tried to find a "column" setting referred to in UNIX: The Complete Reference, Stephen Coffin and in teh ATT 3B2 User and programmer references. No such luck. >> stty columns 80 # this is not really needed, since shell can not >> # reset stty values for parent shell > >This *is* really needed, since this is a line driver thing, not a >shell environment thing. If "stty columns" worked at all you'd be correct! Sorry I did not test this before I went and advertised to the whole planet. However, the general principle of using a shell as a wrapper for calls to INFORMIX programs, such as isql, does work and is often rather useful. You can even pipe the output into sed, awk, etc inside the shell to sort or reformat the output. If you use KSH you can do a lot of powerful output formatting -- so much so that you might use the ksh instead of ACE to do reports (assuming that you don't have INFORMIX-4GL). -- Steve Price UNIX: pacbell!pbhyf!rsprice PHONE: (510)823-1951 Evil can be displaced but never eradicated, as all solutions breed new problems. Yet it is neccessary to keep on struggling toward solution.