DataStage - delete header and footer on the source sequential

How do you you delete header and footer on the source sequential file and how do you create header and footer on target sequential file using datastage?

Showing Answers 1 - 6 of 6 Answers


  • Nov 21st, 2007

In Designer Pallete Development/Debug we can find Head & tail. By using this we can do......


  • May 7th, 2014

"Output --> Properties --> Option --> Filter --> add sed command here" to delete header and footer records

  • Aug 11th, 2015

Use before job UNIX execution and remove the first and last line using sed

  Was this answer useful?  Yes


  • Mar 28th, 2017

Use UNIX command in the sequential file stage
sed -n1!p filename|sed -n $!p

  Was this answer useful?  Yes

Monisha jain

  • Jul 31st, 2017

In sequential file using filter property where we can use UNIX command: sed -e 1d -e 1p

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions