Hi,
How can we add header to the output file?
I need to generate a file which has column name along with the records.
How can I get the column names in the job.
Thanks!!!
saini
Header in the output file
Moderators: chulett, rschirm, roy
If you don't like the column names used in the job design then don't use the option to include column names as the first line in the sequential file. Consider creating a blank text file with just your custom column names as the only line of data. Then, from your job just Append to existing file when writing out the rows.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Is that two different question or the same question?
If you want to add Header, based on content, you can choose, the first name as columsn name option or use After job subroutine or ExecuteCommand Stage.
If Filename should be the header, then prefer the later options, by passing the Filename as parameter.
If you like to pass the filename for all the records, include, "FileNameColumn" option from the Input sequential file stage.
If you want to add Header, based on content, you can choose, the first name as columsn name option or use After job subroutine or ExecuteCommand Stage.
If Filename should be the header, then prefer the later options, by passing the Filename as parameter.
If you like to pass the filename for all the records, include, "FileNameColumn" option from the Input sequential file stage.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'