export a table from db2 without column headers

[sriha]

I created a table in db2 ..and i want to send that table to excel 2013 version..i added power query plugin..everyth ing goes nice..but now i want send my table without column headers because i created already column names in excel..this data from db2 should be send to the existed column names in excel.

[AngocA]

You can use the export command. From the command line, it could be:

db2 "export to myfile.csv of del select * from mytable"

Instead, i9f you want to redirect the output (only columns) and then process it, you can use the x modifier in the db2clp:

db2 -x "select * from mytable"