Hi,
using db2 v9.5 on Linux. I need to export some data from DB2 table and in the target exported file I also need columns names. I tried to use 'export' command but by default it does not export column headers. Is there a way to export a columns names as well? Any other simple to do tip how to get columns names into exported file?
Thanks

How to fetch Column names using a select query?

Here is how I do it:

• export to output_file_temp.del of del select ......
• echo "colname1, colname2, colname3 ...." > output_file.csv
• cat output_file_temp.del >> output_file.csv