By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,738 Members | 1,730 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,738 IT Pros & Developers. It's quick & easy.

simple csv export db2 with *column names*

P: n/a
kk
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
kk wrote:
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!


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.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.