Removing Header and Trailer record of a EBCDIC file
Posted: Wed Jun 10, 2015 1:19 am
I have a EBCDIC file and I am reading it using a Sequential File Stage and Schema File with RCP turned on.
The multi layout file has a header record which is 21 bytes. The Detail records are 2427 bytes long and the trailer record is 9 bytes long.
I managed to remove the header by using tail +22c in the Filter Property of Sequential File Stage. But when tried to remove Header and Trailer I am getting error saying "badly formed number for head command in Filter "
I used command tail +22c |head -2427c
This command if executed in Unix is working fine.
Any Suggestions?
The multi layout file has a header record which is 21 bytes. The Detail records are 2427 bytes long and the trailer record is 9 bytes long.
I managed to remove the header by using tail +22c in the Filter Property of Sequential File Stage. But when tried to remove Header and Trailer I am getting error saying "badly formed number for head command in Filter "
I used command tail +22c |head -2427c
This command if executed in Unix is working fine.
Any Suggestions?