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 - 4 of 4 Answers

Gnaneshwar

  • Nov 21st, 2007
 

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

Kalai

  • May 7th, 2014
 

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

bimaljsr@gmail.com

  • Aug 11th, 2015
 

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

  Was this answer useful?  Yes

sri

  • 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