Search code examples
db2ibm-clouddashdb

DASHDB(DB2)/BLUEMIX(IBM CLOUD): Export CSV with custom separator (not comma)


Is there any way to export a CSV from DASHDB/DB2 in BLUEMIX (IBM CLOUD) with another separator than comma?

My data if full of commas and this separator is useless for me.

Thanks! :)


Solution

  • I have the same problem, I have solved using IBM Data Studio, it´s a IDE based on eclipse, with it you can connect to your ibm db2 on cloud, search in "tables", find your table, right button on your table, and select "Download -> with SQL", change file type to "*.csv" then you can choose the delimiter and field separator.

    enter image description here