Fwd: I should know this - sql output formatting

Or 4GL or ESQL/C or C/C++ & ODBC or Java & JDBC. Lots of other interfaces. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Aug 14, 2009 at 1:07 PM, david@smooth1.co.uk <david@smooth1.co.uk>wrote: > On 14 Aug, 16:34, malc_p <i...@perrior.net> wrote: > > Art Kagel wrote: > > > Andeas's script is neat, but it would be easier to use UNLOAD instead > > > of OUTPUT. The resulting delimited file is far easier to parse. To > > > directly answer your question, you cannot get dbaccess to stop > > > changing the output format for records wider than 80 characters. > > > There are 3rd party tools you can use instead of dbaccess, but if you > > > cannot install those, then UNLOAD is your friend. It is trivial to > > > write a parser and reformatter for the delimited output in awk or perl. > > > > > Art > > > > Yup agreed - that's what I've recommended to the user. > > > > Thanks everyone for the help - and I have indeed persuaded someone in > > development to consider looking at Aubit (although it doesn't help that > > the first hit found on google points towww.4glworks.com, which is > > defunct) & SQSL. > > > > Possible result! > > > > Malc (aka SGboyuk - I have a Gibson & I'm gonna use it! Oh and RIP Les > > Paul) > > Use Perl + DBD/DBI-Informix instead! > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >