All Forums Teradata Applications
dsampath 1 post Joined 12/15
18 Apr 2016
Adding column headers to TPT export files - FILE_WRITER/EXPORT_OPERATOR operator

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"

You must sign in to leave a comment.