Re: dbaccess - select * display

You can write an awk script which will put all the pieces back together again once you hit the blank line which appears between each row. I did this some time ago and it worked well for me. I might try and dig up the script and post it here some day - the only fiddly bit was how to work out the length of each column. On 19 Apr 1996 14:23:17 -0400, clema@informix.com (Clem Akins) wrote: >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 | > |_____________________________________________________________| (c) 1996, All rights reserved. __________________________________________________________ | o o | | Gavin Nour: nourg@acslink.net.au | | Director: Select Software Solutions Pty Ltd. | | Secretary: Informix User Group NSW, Australia. | | Committee member: International Informix User Group. | | Mobile: +(61) 0419 803 113 | | o o | |__________________________________________________________|