DSXchange

Hi,

I need to generate a file with coulumn names like

Date Report Produced and Country, if not USA

I have only 3 stages in job.I have i/p csv file and transformer and sequential file.

In transformer is not permitting me to do this.
Is there any possiblity to do this .

Thanks in advance.

Create a text file of just the column headings you wish, then set the Sequential output stage to APPEND to that file and stream your data to it.

Column names in DataStages are like column names in SQL - there are reserved characters.

The Transformer stage does not use column headings at all, so your diagnosis is incorrect. It is the Sequential File stage with an input link that disallows column headings containing reserved characters.

Ken's suggested solution will work; for example use an echo command in a before-stage subroutine (ExecDOS) to write the header line, and set the Sequential File stage to append to this file.