simple csv export db2 with *column names*

simple csv export db2 with column names

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kk - 28 Oct 2004 23:13 GMT

Hi,

I am trying to set up scheduled export in DB2. DB2 seems to be
missing the ability to export column names for CSV. Apparently
'method N' is only for ixf and wsf files. I have a C# and/or Python
app I can modify but this seems like overkill for such a simple thing.
Any suggestions would be appreciated!

Keith

Reply to this Message

Knut Stolze - 29 Oct 2004 09:03 GMT

> Hi,
>
[quoted text clipped - 3 lines]
> app I can modify but this seems like overkill for such a simple thing.
> Any suggestions would be appreciated!

Could you explain what you want to do?

Column names are not stored in (comma) delimited file. So METHOD N doesn't
make any sense there. And if you want to export only a subset of the
columns, then you can specify those columns in the SELECT statement that is
used to produce the result set to be exported.

Signature

Knut Stolze
Information Integration
IBM Germany / University of Jena

Reply to this Message