Adding column headers to TPT export files - FILE_WRITER/EXPORT_OPERATOR operator

Teradata Applications

Adding column headers to TPT export files - FILE_WRITER/EXPORT_OPERATOR operator

Hi,

I am using EXPORT_OPERATOR() and FILE_WRITER() operators to export data from table into a CSV file.

Is there an option that I can enable in either of these two operators to include the column header in the output file.  This option ususally exists in all client tools and ETL tools.

If there is no option in TPT operators then the alternate option is to use something like "select column headers union select * from table"

Thanks