Re: I should know this - sql output formatting

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 to www.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)

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!