RE: How do a force Fixed width output using 'isqlrf' statement?
Posted in 1998
There are some solutions to this in the IIUG archives at http://www.iiug.org. Some involve using AWK to post-process the output from ISQL or ISQL-RF or DB-Access. Alternatively, SQLCMD (which I wrote) requires ESQL/C but conditionally produces fixed format output (-F fixed), along with a whole lot of other useful features for working with shell scripts. It also does a reasonable approximation to csv (and loads or unloads in this format). Yours, Jonathan Leffler (jleffler@visa.com) #include <bother.ms-exchange.h> ---------- From: tharold@portal.ca[SMTP:tharold@portal.ca] Sent: Friday, April 03, 1998 11:20 AM I am trying to dump data from a table, but want to make sure it comes out in a tabular format (ie: fixed width, or even csv), but I guess I have too many fields for it to default to that. [...]