Pl

[Dolly123]

I have a requirement where I am reading data from the database and writing it to a file but the file should have only one header. I am using batch processing here as I need to read huge volume of data and appending the data to the same file. However, for each transaction header is added, how can I write header only once while writing records multiple times?

can one can tell me ? how to do this 

col1  col2  col3  col4
abc  333  5ad  gag
col1  col2  col3  col4
ddd  455  d44  ggg

Expected Output:

col1  col2  col3  col4
abc  333  5ad  gag
ddd  455  d44  ggg

[micheledenardi]

Can you post your SELECT statement?

Can be something like this:

Select
 col1,
 col2,
 col3,
 col4
From Table Where col1<>'col1';