Hi,

we are using SQL Anywhere 11. When we use interactive sql
for exporting data from a table to a csv-file, we don't see
the column header. Is there a way to export the records and
the column headers into a csv-file?

By,

Filip

I don't know if it helps you can get something like
that through the clipboad by copying the entire
Results pane to an editor or (possibly) some spread
sheet (my copy of Excel requires an extra step of
converting Text-to-Columns).

Otherwise there are no headings for formts TEXT or FIXED
[see OUTPUT statement]. You would need to go with
a formated file format, like HTML or XML ... if those can
help.

There is the option of using the SQL format but that requires
your SQL statement you used to have a full select-list
clause spelled out (a `select * from table` will be a little
disappointing, for example).

Does the {INPUT | OUTPUT} USING connection-string
statement variants help out at all?

Of course, you may be able to add that information yourself
if you are planning of doing that programatically.

In addition to these comments, many other products can import data from our
database.

HTH

"Filip Vanderstappen" wrote in message
news:4af16685.3f1b.1681692777 (AT) sybase (DOT) com...

Filip,

in case you can use ASA 9.0.2 to connect to your database, in Java ISQL
you would just SELECT ... ; OUTPUT TO ... FORMAT XLS and Bob's your uncle.

It's still one of my pet peeves Sybase discontinued this feature. Maybe
now's the time for a re-enhancement request ( newsgroup
sqlanywhere.product_futures_discussion). I would second that.

Reimer

Filip Vanderstappen wrote: