The FileWriter operator can automatically generate header rows containing column names from the DEFINE SCHEMA statement. To enable this feature, set the AddHeaderRow attribute to 'Y'. This is particularly useful when creating files for consumption by spreadsheet applications, data analysis tools, or any application that expects self-describing CSV files.
Header rows are only supported for delimited format files (Format = 'Delimited'). When enabled, a header row is written as the first line of each output file, even when FileSizeMax causes the creation of multiple output files. In WriteAppend mode, headers are intelligently managed: they are written only to new or empty files, preventing header duplication in existing files with data.
For more information, see the AddHeaderRow attribute description.