How to add an header and trailer to a file through datastage

adityavarma · Post by **adityavarma** » Thu Oct 21, 2010 5:01 am

Hi,

I have an requirement where i need to add an header record and a trailer record to an existing data csv file through datastage.

Can anyone please help me on this?

Regards,
Aditya

ray.wurlod · Post by **ray.wurlod** » Thu Oct 21, 2010 5:08 am

What a strange requirement (to do this with DataStage)! You should really do this with operating system commands and redirection operators. To embed those in DataStage is really a waste of resources.

adityavarma · Post by **adityavarma** » Thu Oct 21, 2010 5:47 am

What is the best way to achieve this?

Can we write an unix script and call through the execute command activity? or is there any otehr way.

Thanks
Aditya

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Oct 21, 2010 6:38 am

There are loads of options
1.) Funnel the rows
2.) Before/after calls from job properties
3.) Sequencer calling header and trailer using execute command stage

Ultimately, all will be prepared separately and then combined together.

chulett · Post by **chulett** » Thu Oct 21, 2010 7:18 am

adityavarma wrote:Can we write an unix script and call through the execute command activity?

Sure, but you don't even "need" a script for this - just do the cat work directly there.