Re: dbaccess - select * display

al_dev@candle.com writes: > : Is it possible to display multi-column rows (as in sybase isql) in dbaccess? > : [...] > > 1. Bugger Informix on this one. > 2. Look into the unload command. That might help you. > NB! It's a dbaccess command, not an sql-statement executed by the engine, so > you can't use it in a stored procedure and some other places. You can display multi-column rows if the columns don't extend past the end of the screen. If you are really only interested in a subset of the columns then choose only those. I've been able to fit all the interesting data on-screen by eliminating columns from the display, i.e. SELECT fname, lname FROM cust WHERE city = "Menlo Park"doesn't display the city (which I know), thus saving one column. That's pretty weak, I know, but it sometimes beats "OUTPUT TO filename". _______________________________________________________________ | Clem "RTFM" Akins clema@informix.com | | International Support formerly | | Informix Software, Inc cwakins@leia.alloys.rmc.com | | Menlo Park, California, USA Standard Disclaimers Apply | |_____________________________________________________________|