How do you you delete header and footer on the source sequential file ?
I know we can skip the header in the sequential file datastage stage but I am not sure how to skip the footer. I think the below unix command would work best.
For header sed -n '1p'
and footer sed -n '$p'
For Datastage, I found the following answer on internet
In Designer Pallete Development/Debug we can find Head & tail. By using this we can do......
Tags
Datastage
A better way to do this is to use the 'Filter' option in the Sequential File stage and define the below filter commands -
ReplyDeleteTo remove only header -
sed'1d'
To remove header and footer -
sed '1d:$d'